Обсуждение: Problem with pd_dump and sequence

Поиск
Список
Период
Сортировка

Problem with pd_dump and sequence

От
"Meibell Contreras"
Дата:
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