Home > mailing lists

dump and sequence initilizing - Mailing list pgsql-general

From	Markus Rebbert
Subject	dump and sequence initilizing
Date	December 15, 2003 11:20:22
Msg-id	1071490788.835.328.camel@antichrist.freenet.de Whole thread Raw
Responses	Re: dump and sequence initilizing (Bruno Wolff III <bruno@wolff.to>) Re: dump and sequence initilizing (Sai Hertz And Control Systems <sank89@sancharnet.in>)
List	pgsql-general

Tree view

Hi list,

what happens with sequences if i dump a database and i want to reload
it?

Do i have to initialize the sequences like
SELECT setval('sequence', max(id)) FROM table;
?

Best regards,
Markus

pgsql-general by date:

From: "Manu M P"
Date: 15 December 2003, 09:31:59
Subject: password authentication failed for ..

From: Bruno Wolff III
Date: 15 December 2003, 11:22:57
Subject: Re: dump and sequence initilizing

dump and sequence initilizing - Mailing list pgsql-general

Previous

Next