Re: autoupdate sequences after copy

On Thu, Oct 09, 2003 at 12:10:44PM -0700, CSN wrote:
> On Thursday 09 October 2003 08:10, CSN wrote:
> > Is there a way to have p/k sequences get
> automatically
> > set to max(id)+1 after COPY's like the following?
> >
> > copy table1 (id,name) from stdin;
> > 1 abc
> > 2 def
> > 3 fhi
> > \.
>
> Not really - if you don't use the sequence it keeps
> its value. If you look at
> pg_dump it issues an explicit setval() after a copy.

The problem is when you do
pg_dump -s -t table database > schema
pg_dump -a -t table database > data
edit data
psql -f schema otherdatabase
psql -f data otherdatabase

you then need to quickly
select setval('col_id_seq',(select max(id) from col));
for each sequence.. and not forget..

Cheers,

Patrick