diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-04-29 16:43:54 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-04-29 16:43:54 +0000 |
| commit | a0a0512182cdca33d41485a5399573e6e380c229 (patch) | |
| tree | 3ec313b9b3271701c20dbb2ba220757a64bb21a6 /src/backend/commands/tablecmds.c | |
| parent | 908f317b73c784b7101463d08d6415ef7fd5cb6c (diff) | |
| download | postgresql-a0a0512182cdca33d41485a5399573e6e380c229.tar.gz postgresql-a0a0512182cdca33d41485a5399573e6e380c229.zip | |
Disallow changing DEFAULT expression of a SERIAL column.
Dhanaraj M
Diffstat (limited to 'src/backend/commands/tablecmds.c')
| -rw-r--r-- | src/backend/commands/tablecmds.c | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c index 6483578e808..1ed5fa9bbba 100644 --- a/src/backend/commands/tablecmds.c +++ b/src/backend/commands/tablecmds.c @@ -8,7 +8,7 @@ * * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.181 2006/03/14 22:48:18 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.182 2006/04/29 16:43:54 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -3362,6 +3362,11 @@ ATExecColumnDefault(Relation rel, const char *colName, * safety, but at present we do not expect anything to depend on the * default. */ + if (newDefault) + RemoveSequenceDefault(RelationGetRelid(rel), attnum, DROP_RESTRICT, false); + else + RemoveSequenceDefault(RelationGetRelid(rel), attnum, DROP_RESTRICT, true); + RemoveAttrDefault(RelationGetRelid(rel), attnum, DROP_RESTRICT, false); if (newDefault) |