"PostgreSQL Bugs List" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
