RE: [GENERAL] Re: Unanswered questions about Postgre

2000-12-12 Thread Roger Wernersson
, 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

RE: [GENERAL] Re: Unanswered questions about Postgre

2000-12-12 Thread Edward Q. Bridges
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

RE: [GENERAL] Re: Unanswered questions about Postgre

2000-12-12 Thread Roger Wernersson
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