Hello, I have a following problem:
In short: I can't reload pg_dump --data-only dump (ver. 8.0) back to
the database, because the loading will violate ref. integrity.
The long story:
We have a PgSQL 7.2.5 database, and we like to bring only the data to
the PgSQL 8.0 system. So I did
On Mon, Jan 24, 2005 at 11:16:56AM -0700, Jani Averbach wrote:
What I am doing wrong? Or have I found an ordering bug with pg_dump
when you are doing --data-only dumps?
In a simple test I see the same ordering (alphabetical?) whether I
use --data-only or not. The schema+data dump succeeds
Jani Averbach [EMAIL PROTECTED] writes:
the following won't work:
4) Dump only data from just created 8.0 database:
pg_dump \
--data-only \
--column-inserts \
--use-set-session-authorization \
new_db new_db.data-only.dump
5)
On 2005-01-24 13:46-0500, Tom Lane wrote:
Jani Averbach [EMAIL PROTECTED] writes:
This will fail with lots of these kinds of errors:
ERROR: insert or update on table mytable
violates foreign key constraint mytable_myattr_fkey
Try it with --disable-triggers.
Thanks a