I am using 8.2.17
I added a new schema and moved tables into it using
ALTER TABLE tblname SET SCHEMA newschema;
This moves the sequences referred to by the table to the new schema as
is specified by the manual.
> Associated indexes, constraints, and sequences owned by table columns
> are moved as well.
I was very surprised to find that the default nextval functions still
refer to the sequence public.sequencename
I discovered this when I tried to insert and it told me the sequence
does not exist.
> id integer NOT NULL DEFAULT
Shouldn't this change automatically as well?
Is there an easy way to modify all the default values now?
pgsql-general by date
|Next:||From: A. Kretschmer||Date: 2010-06-29 12:20:51|
|Subject: Re: alter table schema, default sequences stay the same|
|Previous:||From: Vibhor Kumar||Date: 2010-06-29 09:55:58|
|Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II|