> This is fixed in the next version as well as an experimental version for
> 7.0.2 found at:
> The solution (as suggested by Tom Lane) was to sort the items by OID before
> dumping them. This is not a perfect solution, but it will cover 95% of cases.
I tried this new pg_dump. It worked for me very well. But, for a
database with 10000 rows it wasn't too fast dumping out (twice slower than
the original one) and restoring it was three times slower.
Thanks again, Zoltan
In response to
pgsql-hackers by date
|Next:||From: hstenger||Date: 2000-07-31 18:53:33|
|Subject: Managing Rollback|
|Previous:||From: Ross J. Reedstrom||Date: 2000-07-31 18:08:33|
|Subject: Re: Now PostgreSQL recovers from errors within trns|