Problem with pd_dump and sequence

From: "Meibell Contreras" <mcontr(at)loquesea(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem with pd_dump and sequence
Date: 2001-07-17 18:31:33
Message-ID: 9j2085$2511$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello;

I am using postgres 7.1.2 and when I make a pg_dump of a database the
sequence part is generetaed in the ouput file like this:

SELECT setval ('"qreq_idseq"', 1, 'f');

Then; when I restore it.. everything works fine.. less the secuence...
If I change de setval parameter to removing the lasta one:
SELECT setval ('"qreq_idseq"', 1); the restoration is fine...

How I can fix that the pg_dump generate the seceunces whitout the last
parameter?

I tried pg_dump with
pg_dump database > test.out
pg_dump -d database > test.out
and the same problem......

Anybody can help me with this...?

Thanks

Meibell

Browse pgsql-general by date

  From Date Subject
Next Message Buddy Lee Haystack 2001-07-17 19:04:02 Re: Application Design and PostgreSQL
Previous Message nbaizid 2001-07-17 18:16:12 Re: Postmaster