Easy form of "insert if it isn't already there"?

Поиск
Список
Период
Сортировка
От Chris Angelico
Тема Easy form of "insert if it isn't already there"?
Дата
Msg-id CAPTjJmrZHz6X1VnadY1WQytsRTVK4Z-auQaLeJZ29o0-Esg9kw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Easy form of "insert if it isn't already there"?
Список pgsql-general
Periodically I find myself wanting to insert into some table,
specifying the primary key column(s), but to simply ignore the request
if it's already there. Currently I have two options:

1) Do the insert as normal, but suppress errors.
SAVEPOINT foo;
INSERT INTO table (col1,col2,col3) VALUES (val1,val2,val3);
(if error) ROLLBACK TO SAVEPOINT foo;

2) Use INSERT... SELECT:
INSERT INTO table (col1,col2,col3) SELECT val1,val2,val3 WHERE NOT
EXISTS (SELECT * FROM table WHERE col1=val1 AND col2=val2)

The former makes unnecessary log entries, the latter feels clunky. Is
there some better way?

All tips appreciated!

Chris Angelico

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

Предыдущее
От: Venkat Balaji
Дата:
Сообщение: Re: [GENERA]: Postgresql-9.1.1 synchronous replication issue
Следующее
От: Venkat Balaji
Дата:
Сообщение: Re: High checkpoint_segments