summaryrefslogtreecommitdiffstats
path: root/Bugzilla/DB
diff options
context:
space:
mode:
authorMax Kanat-Alexander <mkanat@bugzilla.org>2010-07-13 02:38:53 +0200
committerMax Kanat-Alexander <mkanat@bugzilla.org>2010-07-13 02:38:53 +0200
commit47eb776b6c3b5e92bc13394440d99440cb2a4235 (patch)
tree708f94fc92f50d178439b0d8edb88d723d2a1e79 /Bugzilla/DB
parent31ffa56311523fcd47e2ae99f8636586cd005c56 (diff)
downloadbugzilla-47eb776b6c3b5e92bc13394440d99440cb2a4235.tar.gz
bugzilla-47eb776b6c3b5e92bc13394440d99440cb2a4235.tar.xz
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)
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r--Bugzilla/DB/Pg.pm6
1 files changed, 6 insertions, 0 deletions
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')");
}
}
}