diff options
| -rw-r--r-- | Bugzilla/DB/Schema/Pg.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/Bugzilla/DB/Schema/Pg.pm b/Bugzilla/DB/Schema/Pg.pm index 31eedadcb..517837dcc 100644 --- a/Bugzilla/DB/Schema/Pg.pm +++ b/Bugzilla/DB/Schema/Pg.pm @@ -134,9 +134,10 @@ sub _get_alter_type_sql { if ($type =~ /serial/i && $old_def->{TYPE} !~ /serial/i) { die("You cannot specify a DEFAULT on a SERIAL-type column.") if $new_def->{DEFAULT}; - $type =~ s/serial/integer/i; } + $type =~ s/\bserial\b/integer/i; + # On Pg, you don't need UNIQUE if you're a PK--it creates # two identical indexes otherwise. $type =~ s/unique//i if $new_def->{PRIMARYKEY}; |