From a0a0512182cdca33d41485a5399573e6e380c229 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sat, 29 Apr 2006 16:43:54 +0000
Subject: Disallow changing DEFAULT expression of a SERIAL column.

Dhanaraj M
---
 src/backend/commands/tablecmds.c | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'src/backend/commands')

diff --git a/src/backend/commands/tablecmds.c b/src/backend/commands/tablecmds.c
index 6483578e80..1ed5fa9bbb 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)
-- 
cgit v1.2.3