|
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 |
