Sequences with pg_dump -a not properly set - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Sequences with pg_dump -a not properly set
Date
Msg-id 200107072059.f67Kxn940948@hub.org
Whole thread Raw
List pgsql-bugs
HERVE Laurent (laurent_herve@infonie.fr) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Sequences with pg_dump -a not properly set

Long Description
I use PostgreSQL 7.0.3

When I use the pg_dump -a, the script contains CREATE SEQUENCE statements for loading data for sequences.
As the sequence already exists, the statement fails when I try to load the dump (for data only). It should have
generatedsetval statements or something equivalent... 



Sample Code


No file was uploaded with this report

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: can't create timestamp field (only timestamp with time zone)
Next
From: Namrata
Date:
Subject: problem with compilation!