bulk insert unique contraint

Поиск
Список
Период
Сортировка
От Janek Sendrowski
Тема bulk insert unique contraint
Дата
Msg-id trinity-4ad2fe0e-47ed-4abe-87c3-28b1b69319f3-1388412840473@3capp-webde-bs21
обсуждение исходный текст
Ответы Re: bulk insert unique contraint
Список 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'musing 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


В списке pgsql-general по дате отправления: