From 47eb776b6c3b5e92bc13394440d99440cb2a4235 Mon Sep 17 00:00:00 2001
From: Max Kanat-Alexander <mkanat@bugzilla.org>
Date: Mon, 12 Jul 2010 17:38:53 -0700
Subject: Bug 578197: [PostgreSQL] When associating sequences with columns,
 also fix the default of the columns so that it's identical to what a new
 checksetup run would create. r=mkanat, a=mkanat (module owner)

---
 Bugzilla/DB/Pg.pm | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'Bugzilla')

diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index 8ed7368aa..0373fb1ce 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -296,6 +296,12 @@ END
                 print "Fixing $sequence to be associated"
                       . " with $table.$column...\n";
                 $self->do("ALTER SEQUENCE $sequence OWNED BY $table.$column");
+                # In order to produce an exactly identical schema to what
+                # a brand-new checksetup.pl run would produce, we also need
+                # to re-set the default on this column.
+                $self->do("ALTER TABLE $table
+                          ALTER COLUMN $column
+                           SET DEFAULT nextval('$sequence')");
             }
         }
     }
-- 
cgit v1.2.3-24-g4f1b