Dear Tom

Thanks for your email.

You are right in saying table is already populated with the data. I was
testing the pg_dump and pg_restore using pg_Admin III.

I am having the impression that pg_restore would over-rides the "old"
data with the current one. Is my thinking wrong?  I have checked the
documentation but it was silence on this.  Does it means that whenever
I performed a pg_restore, I must first drop the "old" database.

I would be glad if you can help to clarify my understanding on
pg_dump and pg_restore functions.

Thank you.

CY


Tom Lane <[EMAIL PROTECTED]> wrote:
Infor Gates <[EMAIL PROTECTED]> writes:
> I hope you could help me understand the error message below:
> While it looks straight forward, I could NOT find the duplicate key violation,

Considering that it's complaining at the very first line of COPY data,
I wonder whether you aren't restoring into a table that already contains
the data you want to load. pg_restore doesn't (by default) try to
delete data that's already present.

regards, tom lane


Yahoo! Groups gets better. Check out the new email design. Plus there’s much more to come.

Reply via email to