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.
In response to
pgsql-admin by date
|Next:||From: Mendola Gaetano||Date: 2003-06-27 00:18:52|
|Subject: Postgres RoadMap|
|Previous:||From: Mendola Gaetano||Date: 2003-06-26 22:56:22|
|Subject: 7.4 Documetation|