dump and sequence initilizing

From: Markus Rebbert <markus(dot)rebbert(at)freenet(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: dump and sequence initilizing
Date: 2003-12-15 12:19:48
Message-ID: 1071490788.835.328.camel@antichrist.freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-12-15 12:22:16 Re: dump and sequence initilizing
Previous Message Manu M P 2003-12-15 10:31:23 password authentication failed for ..