Re: ALTER TABLE RENAME column

"Mario Weilguni" <mario.weilguni@icomedias.com> 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