Dear listI hope you could help me understand the error message below:While it looks straight forward, I could NOT find the duplicate key violation,even though check through the said table (transaction by transaction). So,I am wondering if the message would means something else.I had tried re-indexi
ve checked thedocumentation but it was silence on this. Does it means that wheneverI 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.CYTom Lane <[EMAIL PROTECTED]>
e. It helps us test our code rollouts. -AaronOn 6/18/06, Tom Lane <[EMAIL PROTECTED]>
wrote: Infor Gates <[EMAIL PROTECTED]> writes:> I am having the impression that pg_restore would over-rides the "old"> data with the current one. Is my thinking wrong? Yeah. By defau
