From: | "Josh Goldberg" <josh(at)4dmatrix(dot)com> |
---|---|
To: | "Bruno Wolff III" <bruno(at)wolff(dot)to> |
Cc: | "Michael Kovalcik" <makd32(at)yahoo(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: How do I select the last Id in a column??? |
Date: | 2003-06-30 18:07:21 |
Message-ID: | 038001c33f32$74081fb0$6e02a8c0@4dmatrix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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" <bruno(at)wolff(dot)to>
To: "Josh Goldberg" <josh(at)4dmatrix(dot)com>
Cc: "Michael Kovalcik" <makd32(at)yahoo(dot)com>; <pgsql-admin(at)postgresql(dot)org>
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 <josh(at)4dmatrix(dot)com> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Chris G. Nicholas | 2003-06-30 18:48:15 | big tables with lots-o-rows |
Previous Message | scott.marlowe | 2003-06-30 17:10:36 | Re: Help. Pg not running |