Re: [GENERAL] Deduplication and transaction isolation level

2013-09-25 Thread DDT
ginal -- From: "Steven Schlansker";; Date: Thu, Sep 26, 2013 01:50 AM To: "Merlin Moncure"; Cc: "François Beausolei"; "Forums postgresql"; Subject: Re: [GENERAL] Deduplication and transaction isolation level On Sep 25, 2013, at 6:04 AM, Merlin

Re: [GENERAL] Deduplication and transaction isolation level

2013-09-25 Thread Merlin Moncure
On Wed, Sep 25, 2013 at 12:50 PM, Steven Schlansker wrote: > > On Sep 25, 2013, at 6:04 AM, Merlin Moncure wrote: > >> On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil >> wrote: >>> Hi all! >>> >>> I import many, many rows of data into a table, from three or more >>> computers, 4 times per

Re: [GENERAL] Deduplication and transaction isolation level

2013-09-25 Thread Steven Schlansker
On Sep 25, 2013, at 6:04 AM, Merlin Moncure wrote: > On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil > wrote: >> Hi all! >> >> I import many, many rows of data into a table, from three or more computers, >> 4 times per hour. I have a primary key, and the query I use to import the >> da

Re: [GENERAL] Deduplication and transaction isolation level

2013-09-25 Thread François Beausoleil
Le 2013-09-25 à 09:04, Merlin Moncure a écrit : > On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil > wrote: >> Hi all! >> >> I import many, many rows of data into a table, from three or more computers, >> 4 times per hour. I have a primary key, and the query I use to import the >> data i

Re: [GENERAL] Deduplication and transaction isolation level

2013-09-25 Thread Merlin Moncure
On Tue, Sep 24, 2013 at 10:19 PM, François Beausoleil wrote: > Hi all! > > I import many, many rows of data into a table, from three or more computers, > 4 times per hour. I have a primary key, and the query I use to import the > data is supposed to dedup before inserting, but I still get primar

[GENERAL] Deduplication and transaction isolation level

2013-09-24 Thread François Beausoleil
Hi all! I import many, many rows of data into a table, from three or more computers, 4 times per hour. I have a primary key, and the query I use to import the data is supposed to dedup before inserting, but I still get primary key violations. The import process is: * Load CSV data into temp ta