, 12);
END;
-Original Message-
From: Edward Q. Bridges [mailto:[EMAIL PROTECTED]]
Sent: den 12 december 2000 17:10
To: PostgreSQL general mailing list; Roger Wernersson
Subject: RE: [GENERAL] Re: Unanswered questions about Postgre
On Tue, 12 Dec 2000 12:04:46 +0100, Roger Wernersson wrot
On Tue, 12 Dec 2000 12:04:46 +0100, Roger Wernersson wrote:
>
> I can't BEGIN - SELECT FOR UPDATE - INSERT or UPDATE - COMMIT as someone
> might insert after my SELECT and before my INSERT.
>
correct me if i'm wrong, but a select for update locks the table for
an insert or an update until the
How do you mean "reliable"?
This raises an interesting question though. How do I _reliably_ INSERT or
UPDATE a row?
I can't INSERT - fail - UPDATE as someone might delete the record in between
my two statements.
I can't BEGIN - INSERT - fail - UPDATE - COMMIT as the failing INSERT will
invalida