| 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: | Whole Thread | Raw Message | 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
| 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 |