bulk insert unique contraint

From: "Janek Sendrowski" <janek12(at)web(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: bulk insert unique contraint
Date: 2013-12-30 14:14:00
Message-ID: trinity-4ad2fe0e-47ed-4abe-87c3-28b1b69319f3-1388412840473@3capp-webde-bs21
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
 
I want to insert data in my table and I want to insert the rows, which don't violates the unique contraint of my id. I'm using a 64bit hash for my it.
If I do one insert statement, which inserts many rows it doesn't do anything if one row violates the unique contraint.
Is there a faster way than using multiple insert statements?
 
Janek

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2013-12-30 15:08:14 Re: bulk insert unique contraint
Previous Message Tim Kane 2013-12-30 14:10:38 Re: ON_ERROR_EXIT and interactive mode (or, how to force interactive mode off)