I did, and the second transaction wouldn't even complete the insert until the first transaction commit'd or rollback'd. I created two new tables and tried on there and it produced the expected behaviour, but several of my existing tables do not.
I changed my code to use currval from now on, just to play it safe :-) ----- Original Message ----- From: "Bruno Wolff III" <[EMAIL PROTECTED]> To: "Josh Goldberg" <[EMAIL PROTECTED]> Cc: "Michael Kovalcik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 4:48 PM Subject: Re: [ADMIN] How do I select the last Id in a column??? > On Fri, Jun 27, 2003 at 10:06:41 -0700, > Josh Goldberg <[EMAIL PROTECTED]> wrote: > > What could cause a table to act serialized when read committed transactions > > are set in the configuration? That is something I am running into, which > > provoked my [incorrect] example. > > Getting lucky. Did you actually run two transactions in parallel and stop > between the select and insert so that you could do a select, insert and > commit in the other transaction? > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
