| From: | "Gnanakumar" <gnanam(at)zoniac(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | On duplicate ignore |
| Date: | 2012-01-18 11:04:28 |
| Message-ID: | 019901ccd5d0$f4a1cca0$dde565e0$@com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
Ours is a web-based application. We're trying to implement ON DUPLICATE
IGNORE for one of our application table, named EMAILLIST. After a quick
Google search, I'm finding the following "easy & convenient" single SQL
statement syntax to follow with:
INSERT INTO EMAILLIST (EMAIL)
SELECT 'john(at)example(dot)net'
WHERE NOT EXISTS (SELECT 1 FROM EMAILLIST WHERE EMAIL =
'john(at)example(dot)net');
My question is, in a single threaded INSERT, this will *definitely* work.
Since ours is a web-based application, will this work out in a concurrent
multi-threaded environment too? In other words, will it be truly unique
when INSERT calls are concurrent?
Regards,
Gnanam
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Volodymyr Kostyrko | 2012-01-18 11:11:55 | scenario with a slow query |
| Previous Message | Jasen Betts | 2012-01-18 10:46:50 | Re: Appending a newline to a column value - in a psql cronjob |