From: | Haroldo Stenger <hstenger(at)adinet(dot)com(dot)uy> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Abort state on duplicated PKey in transactions |
Date: | 2001-09-08 16:46:01 |
Message-ID: | 3B9A4B49.37E2890A@adinet.com.uy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martijn van Oosterhout wrote:
> The usual way is to generate your primarys keys from a sequence. Then you
> never get duplicate values and so the inserts never fail.
>
> This may not apply in your situation...
Both are true, thanks. We need a layer that doesn't complain when a
failing insert is issued. In DB apps, many times a procedure, tries to
insert a record, and if it already exists, then it updates the record.
But since that pair of commands, may be late in a bigger transaction, a
failing insert shoudn't abort the transaction. So, I want to find a way
of avoiding a failing insert. Any other ideas?
This is important, since in a couple of weeks, we will be announcing
GeneXus support for PostgreSQL, and a lot of exitement is being
generated out of this. That announcement will be done in a commercial
and entepreneurial international event, which is fresh water for us
PostgreSQL enthusiasts.
Regards,
Haroldo.
From | Date | Subject | |
---|---|---|---|
Next Message | Vince Vielhaber | 2001-09-08 17:14:44 | Re: Idea: jobs.postgresql.org |
Previous Message | Marc Lambrichs | 2001-09-08 15:44:02 | enumeration datatype in postgresql? |