Postgres Pro
Downloads
Home   >   mailing lists

Re: dump and sequence initilizing - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: dump and sequence initilizing
Date
Msg-id 20031215122216.GB19153@wolff.to
Whole thread Raw
In response to dump and sequence initilizing  (Markus Rebbert <markus.rebbert@freenet.de>)
List pgsql-general
Tree view 
On Mon, Dec 15, 2003 at 13:19:48 +0100,
  Markus Rebbert <markus.rebbert@freenet.de> wrote:
> 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;
> ?

Sequence values should be part of the dump.

pgsql-general by date:

Previous
From: Markus Rebbert
Date:
Subject: dump and sequence initilizing
Next
From: "Johnson, Shaunn"
Date:
Subject: PostgreSQL on Windows Server 2003