On Tue, Apr 20, 2004 at 21:14:48 +0200,
"H.J. Sanders" <hjs(at)worldonline(dot)nl> wrote:
>
> Hello list.
>
> We are migrating from Informix to PSQL.
>
> In Informix we used to do:
>
> - BEGIN WORK
>
> - INSERT ROW
>
> - IF FAILED THEN UPDATE ROW
>
> - COMMIT WORK
>
>
> In PSQL this does not seem to work because after the first error (the
> insert)
> everything is omitted.
>
> Has someone found a solution for this (we have 1000's of this type).
This question has come up a few times over the last year and there isn't
a great answer. Locking the table is a simple solution, but can lead to
problems because of contention.