diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-06-27 03:21:55 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-06-27 03:21:55 +0000 |
| commit | 424b8e64c7dcaf82475785287ff4f38abcfd5e67 (patch) | |
| tree | a87b151dc4809992b36fe6a40eb63692b1d89c7c /src/backend/commands/tablecmds.c | |
| parent | ba4b9c0d8cfb90f2906f968e9890ba5014405bf4 (diff) | |
| download | postgresql-424b8e64c7dcaf82475785287ff4f38abcfd5e67.tar.gz postgresql-424b8e64c7dcaf82475785287ff4f38abcfd5e67.zip | |
Disallow changing/dropping 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 2d80f6c536b..825245ae8d7 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.185 2006/06/16 18:42:21 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/commands/tablecmds.c,v 1.186 2006/06/27 03:21:54 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -3365,6 +3365,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) |