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 sch
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 th
"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 wit
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=ba
"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 vi
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
