Re: [GENERAL] bulk insert unique contraint

2013-12-30 Thread Janek Sendrowski
Hi Salah Jubeh,   I'm not in hurry ;) Thanks for your answer. Thats what I've been searching for.   Janek Sendrwoski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] bulk insert unique contraint

2013-12-30 Thread salah jubeh
>>Hello Janek, >>>which inserts many rows it doesn't do anything if one row violates the >>>unique contraint. >>You insert your data in a transactional way, this is the default behaviour . >>To work around it,  do not insert data like >>INSERT INTO VALUES (),()...; >>but >>INSERT INTO VALUES

Re: [GENERAL] bulk insert unique contraint

2013-12-30 Thread Janek Sendrowski
Hi Salah Jubeh,   My files don't have this format. Could it make sense to create such a file with php and import the data from it? Or ist also possible the get certain rows from the file with regexp?   Janek -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] bulk insert unique contraint

2013-12-30 Thread Andy Colson
On 12/30/2013 8:14 AM, Janek Sendrowski wrote: 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 viol

[GENERAL] bulk insert unique contraint

2013-12-30 Thread Janek Sendrowski
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