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 > ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
