Re: currval() race condition on server?

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Adriaan Joubert <a(dot)joubert(at)albourne(dot)com> writes:
> For some bookkeeping purposes I need the new audit number back from the 
> update, so I submit a prepared statement through jdbc of the form
>
> UPDATE A SET ....; SELECT currval('ip_audit_seq');

It's not possible to put two SQL commands into one prepared statement
--- at least not for the normal server-side meaning of "prepared statement".
I dunno what the JDBC driver is doing with this, but I wonder if it's
silently dropping the UPDATE part :-(

			regards, tom lane