From: | "Wim Ceulemans" <wim(dot)ceulemans(at)pophost(dot)eunet(dot)be> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Sequences : getting back the nextval() result on an insert |
Date: | 1998-06-11 09:40:20 |
Message-ID: | 000901bd951c$f3e5d2b0$67faa8c0@aladdin.nice.be |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
I am new to this list, but I've carefully searched the archives before posting this question.
I am using JDBC to access postgreSQL 6.3.
If one inserts records using a sequence to generate an auto-increment primary key, then you can get back the result by using "select currval('seq')". There is always a time between the insert and the select to retrieve the newly created primary key. What I do in my application is insert a record and display it in a java swing JTable (including the primary key).
How can I be certain that the primary key I retrieve with select currval('seq') is the one just inserted? Because in heavily loaded multi-user systems someone else can insert a record in the same table between my insert and my select.
Regards
Wim Ceulemans
Nice Software Solutions
wim(dot)ceulemans(at)pophost(dot)eunet(dot)be
From | Date | Subject | |
---|---|---|---|
Next Message | Marin D | 1998-06-11 10:00:37 | Re: [GENERAL] Sequences : getting back the nextval() result on an insert |
Previous Message | Oleg Broytmann | 1998-06-11 09:31:54 | Re: [QUESTIONS] SQL statement |