Re: Bulkloading using COPY - ignore duplicates? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bulkloading using COPY - ignore duplicates?
Date
Msg-id 23205.1001945353@sss.pgh.pa.us
Whole thread Raw
In response to Bulkloading using COPY - ignore duplicates?  (Lee Kindness <lkindness@csl.co.uk>)
Responses Re: Bulkloading using COPY - ignore duplicates?
List pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at> writes:
> I thought that the problem was, that you cannot simply skip the 
> insert, because at that time the tuple (pointer) might have already 
> been successfully inserted into an other index/heap, and thus this was 
> only sanely possible with savepoints/undo.

Hmm, good point.  If we don't error out the transaction then that tuple
would become good when we commit.  This is nastier than it appears.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bulkloading using COPY - ignore duplicates?
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Moving CVS files around?