Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name
Date
Msg-id 20666.1100279992@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> if I alter table atable alter field1 rename to field2
> it becomes atable(field2 Serial)
> however, the sequence stays: atable_field1_seq
> it's not tablename_fieldname_seq any more

It's intended to do that.

> This will cause problem when we restore a backup:

pg_dump in 8.0 has a workaround for this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: "strange" rule behavior with nextval on new.* fields
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1317: plPHP does not recgnize booleans