transaction - Mailing list pgsql-sql

From H.J. Sanders
Subject transaction
Date
Msg-id KIEBKBGIGGNDKKJJNKCFOELJCJAA.hjs@worldonline.nl
Whole thread Raw
Responses Re: transaction  (Bruno Wolff III <bruno@wolff.to>)
Re: transaction  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
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).

Henk Sanders










pgsql-sql by date:

Previous
From: "David B"
Date:
Subject: Syntax for cmd to EXEC...how many quotes?
Next
From: ow
Date:
Subject: Follow-up: FK constraint performance