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