From: | "Joshua L(dot) San Juan" <josh(dot)sanjuan(at)q-linux(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump incorrect sequence value |
Date: | 2003-09-03 05:49:00 |
Message-ID: | 1062568139.10952.18.camel@joshua.q-linux.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I had dumped data using the command:
pg_dump -U dbowner dbname -a -t table -f table-data.sql
two tables (e.g. table1, table2).
In the first table - the correct sequence was set as can
be seen at the end of the dump file:
....
SELECT pg_catalog.setval ('table1_id_seq', 20, true);
but in the second table - the sequence was incorrect:
...
SELECT pg_catalog.setval ('table2_id_seq', 1, true);
Question:
How do I correct this so that dumping data sets the
correct sequence value?
Using:
Red Hat 8
Linux 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 GNU/Linux
postgresql-libs-7.3.3-1PGDG
postgresql-tcl-7.3.3-1PGDG
postgresql-server-7.3.3-1PGDG
postgresql-7.3.3-1PGDG
postgresql-libs-7.2.2-1
postgresql-contrib-7.3.3-1PGDG
TIA,
Joshua
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-09-03 06:35:10 | Re: Debian Woody 7.3.4 packages? |
Previous Message | Alvaro Herrera | 2003-09-03 03:47:22 | Re: French translation |