On 1/22/2014 10:21 AM, joocom wrote:
Some days ago, i had to to implement an upsert and used a a/LOCK TABLE/ to
prevent the race conditions. Working fine for the moment.
http://www.joocom.de/blog/postgresql-insert-und-update-in-einem-statement/
<http://www.joocom.de/blog/postgresql-insert-und-update-in-einem-statement/>
that won't perform very well if you have a high level of concurrency.
have you seen the upsert example in the postgres plpgsql docs ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
