Re: upsert functionality - Mailing list pgsql-general

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