| From: | Jan Danielsson <jan(dot)danielsson(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Last Id? |
| Date: | 2005-09-04 18:01:47 |
| Message-ID: | 431B368B.6010109@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello all,
I know how do do this in IBM DB2 and MySQL, but now my interrest has
shifted towards postgresql; I need to be able to insert a row, and find
out which id it was assigned. (I'm talking about using sequences here).
I have seen a few "currval", "last_value", tricks and such, but they
aren't good enough, AFAICT, since they only work when I can guarantee
that no one else will insert a new record between the time that I insert
one, and query for the last_value.
In IBM DB2 and MySQL there's a connection specific "last id" value
which can be queried. I assume there's something similar in postgresql
-- but what is it?
--
Kind Regards,
Jan Danielsson
Te audire no possum. Musa sapientum fixa est in aure.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-04 22:45:57 | Re: UPDATE: pg_dump fails due to invalid memory request |
| Previous Message | Michael Fuhr | 2005-09-04 02:34:06 | Re: UPDATE: pg_dump fails due to invalid memory request |