"Jan-Peter Seifert" <jan-peter.seif...@gmx.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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
