diff options
| author | Bruce Momjian <bruce@momjian.us> | 2002-04-24 02:38:58 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2002-04-24 02:38:58 +0000 |
| commit | adf7cc04cb333bc974aff089313d136ad4f924a5 (patch) | |
| tree | 5caf6317868cb773353c186901ce8ff746812d26 /src/backend/commands/tablecmds.c | |
| parent | 9fcc1159be1df5808e73910f92305e06e9d90075 (diff) | |
| download | postgresql-adf7cc04cb333bc974aff089313d136ad4f924a5.tar.gz postgresql-adf7cc04cb333bc974aff089313d136ad4f924a5.zip | |
Doc fix for INSERT ... (DEFAULT, ...)
Appears I forgot to update the docs earlier.
Rod Taylor
Diffstat (limited to 'src/backend/commands/tablecmds.c')
| -rw-r--r-- | src/backend/commands/tablecmds.c | 12 |
1 files changed, 9 insertions, 3 deletions
diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index c554bba4be3..952496fc1df 100644 --- a/src/backend/commands/tablecmds.c +++ b/src/backend/commands/tablecmds.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/commands/tablecmds.c,v 1.7 2002/04/22 21:56:06 tgl Exp $ + * $Header: /cvsroot/pgsql/src/backend/commands/tablecmds.c,v 1.8 2002/04/24 02:38:58 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -620,8 +620,14 @@ AlterTableAlterColumnDefault(Oid myrelid, rel = heap_open(myrelid, AccessExclusiveLock); - if (rel->rd_rel->relkind != RELKIND_RELATION) - elog(ERROR, "ALTER TABLE: relation \"%s\" is not a table", + /* + * We allow defaults on views so that INSERT into a view can have + * default-ish behavior. This works because the rewriter substitutes + * default values into INSERTs before it expands rules. + */ + if (rel->rd_rel->relkind != RELKIND_RELATION && + rel->rd_rel->relkind != RELKIND_VIEW) + elog(ERROR, "ALTER TABLE: relation \"%s\" is not a table or view", RelationGetRelationName(rel)); if (!allowSystemTableMods |