Re: GetLastInsertID ?

Поиск
Список
Период
Сортировка
Искать
От
Mike Nolan
Тема
Re: GetLastInsertID ?
Дата
Msg-id
200401041847.i04IlLBd020297@gw.tssi.com
Ответ на
Re: GetLastInsertID ? (Martijn van Oosterhout)
Список
Дерево обсуждения
GetLastInsertID ? Stephane Pinel <spinel@noos.fr>
Re: GetLastInsertID ? Dave Cramer <pg@fastcrypt.com>
Re: GetLastInsertID ? Oliver Elphick <olly@lfix.co.uk>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Dennis Bjorklund <db@zigo.dhs.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Dave Cramer <pg@fastcrypt.com>
Re: GetLastInsertID ? Martin Marques <martin@bugs.unl.edu.ar>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Tom Lane <tgl@sss.pgh.pa.us>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Doug McNaught <doug@mcnaught.org>
Re: GetLastInsertID ? Mike Nolan <nolan@gw.tssi.com>
Re: GetLastInsertID ? Martijn van Oosterhout <kleptog@svana.org>
Re: GetLastInsertID ? Tom Lane <tgl@sss.pgh.pa.us>
Re: GetLastInsertID ? Stephane Pinel <spinel@noos.fr>
> Where do you get that impression? currval() refers to the last ID for the
> session you are in. It's also FAQ question 4.15.3. Even better, if you
> havn't used nextval() in your current session, currval() returns an error,
> so you can't even get it wrong by accident.

I stand corrected.  I was doing some testing of a PHP module that is
called from a web form a while back and got inconsistent results with 
currval, I probably had a script error of some kind. 
--
Mike Nolan
В списке pgsql-general по дате отправления
От: Scott Ribe
Дата:
От: A E
Дата:
FAQ