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-27 17:06:41 |
Message-ID: | 02a101c33cce$7af916a0$6e02a8c0@4dmatrix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From: "Bruno Wolff III" <bruno(at)wolff(dot)to>
Sent: Thursday, June 26, 2003 4:30 PM
> On Thu, Jun 26, 2003 at 14:00:33 -0700,
> Josh Goldberg <josh(at)4dmatrix(dot)com> wrote:
> > to get the last record inserted just
> > select * from row order by autoincId desc limit 1;
> >
> > if you have several clients doing this you might want to put your insert
and
> > the select inside a transaction.
>
> That won't help. Your suggestion will only work in serializable
transactions.
>
> In read committed mode the select might see a value for autoincId from
> a transaction that committed between the insert and the select.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Haddon | 2003-06-27 17:55:41 | Japanese Character Support |
Previous Message | Sam Barnett-Cormack | 2003-06-27 15:49:41 | Re: A problem |