Problem with pd_dump and sequence - Mailing list pgsql-general

From Meibell Contreras
Subject Problem with pd_dump and sequence
Date
Msg-id 9j2085$2511$1@news.tht.net
Whole thread Raw
List 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






pgsql-general by date:

Previous
From: nick@methodmaker.co.nz (Nicholas)
Date:
Subject: Licensing of SPIs
Next
From: Víctor Romero
Date:
Subject: Re: [HACKERS] Translators wanted