Re: BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Hongyi Gao" <admin(at)listfusion(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name
Date: 2004-11-12 17:19:52
Message-ID: 20666.1100279992@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-11-12 19:50:33 BUG #1317: plPHP does not recgnize booleans
Previous Message PostgreSQL Bugs List 2004-11-12 16:57:54 BUG #1316: Alter Name of a Serial Field won't change the corresponding SEQUENCE name