"Mario Weilguni" <[EMAIL PROTECTED]> writes: > IMO this should do: > Alter sequence foo_bar_seq rename to foo_baf_seq; > Alter table foo alter baf set default nextval('foo_baf_seq')
No, it should not, because that risks breaking other references to the sequence (eg, in user-written functions). If the user is feeling that he wants consistency, he can rename the sequence himself and take responsibility for any side-effects on his code. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org