Re: Safe upsert/merge from servlet

On Fri, Oct 16, 2009 at 12:05 AM, Jonas Donovan Hansen
<jonasdonovan@hotmail.com> wrote:
> Postgres don’t have an upsert/merge command – how does everybody deal with
> this from an servlet (multi-thread)?


Postgresql doesn't have support for merge at this time as an SQL
command.  However, I've seen some functions developed to simulate
this: http://www.postgresql.org/docs/current/static/plpgsql-control-structures.html#PLPGSQL-UPSERT-EXAMPLE

Regarding the second point, the manual show the capabilities of the
JDBC driver and postgresql:
http://jdbc.postgresql.org/documentation/84/thread.html

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug