All, i got the answer i was needing. I used the following:
select max(id) from table it works great!! :) --- 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. > > From: "Bruno Wolff III" <[EMAIL PROTECTED]> > Sent: Thursday, June 26, 2003 4:30 PM > > On Thu, Jun 26, 2003 at 14:00:33 -0700, > > Josh Goldberg <[EMAIL PROTECTED]> 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 > > > __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
