Re: BUG #4582: Renaming sequences and default value

"Jan-Peter Seifert" <jan-peter(dot)seifert(at)gmx(dot)de> writes:
> there's a problem with renaming sequences in our databases.

I don't think there's really a problem here. You've apparently got some
obsolete syntax in your CREATE commands:

> id integer NOT NULL DEFAULT nextval(('public.t2_id_seq'::text)::regclass)

This specifically says that 'public.t2_id_seq' is a string (text) constant,
which is not going to change in response to anything. If you would
like it to track renamings of the sequence then it needs to be a
regclass constant:

id integer NOT NULL DEFAULT nextval('public.t2_id_seq'::regclass)

Also, neither of these forms will by itself establish an OWNED BY
relationship --- you'll need a separate ALTER SEQUENCE OWNED BY
command if you want that.

If that doesn't help, you'll need to be a lot more specific about the
actions you took.

regards, tom lane