On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm having trouble with a dump and restore:
$ pg_dump --format=t --schema=babase --data-only --user babase_admin
babase_test | pg_restore --data-only --disable-triggers --user
babase_admin --dbname=babase
Karl O. Pinc [EMAIL PROTECTED] writes:
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...
That's what I thought at first, except that I had just created
the db structure with a
On 05/09/2006 10:24:28 AM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Um ... it looks to me like you're trying to restore into an
existing
table that already has the same data loaded ...
I'm not clear on where to start with this.
On 05/08/2006 06:42:18 PM, Tom Lane wrote:
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm having trouble with a dump and restore:
Um ... it looks to me like you're trying to restore into an existing
table that already has the same data loaded ...
Thanks everybody, the problem was in the schemas
Hello,
PostgreSQL 8.1.3, Centos 4.2
I'm having trouble with a dump and restore:
$ pg_dump --format=t --schema=babase --data-only --user babase_admin
babase_test | pg_restore --data-only --disable-triggers --user
babase_admin --dbname=babase
pg_restore: ERROR: duplicate key violates unique
Karl O. Pinc [EMAIL PROTECTED] writes:
I'm having trouble with a dump and restore:
$ pg_dump --format=t --schema=babase --data-only --user babase_admin
babase_test | pg_restore --data-only --disable-triggers --user
babase_admin --dbname=babase
pg_restore: ERROR: duplicate key violates