Re: [BUGS] BUG #4582: Renaming sequences and default value

2008-12-16 Thread Tom Lane
Jan-Peter Seifert writes: > Tom Lane wrote: >> 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) > ... But then I saw the difference in nextval synt

Re: [BUGS] BUG #4582: Renaming sequences and default value

2008-12-16 Thread Jan-Peter Seifert
Tom Lane wrote: Thank you very much for your quick reply. I wanted to do some testing before reporting back. > "Jan-Peter Seifert" 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 synta

Re: [BUGS] BUG #4582: Renaming sequences and default value

2008-12-15 Thread Tom Lane
"Jan-Peter Seifert" 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 specific