currval - Mailing list pgsql-sql

From Craig May
Subject currval
Date
Msg-id 20001002045620.B6334@s2.enthdimension.com.au
Whole thread Raw
List pgsql-sql
Hi,

I'm executing the following statements in series.  

insert into [tablename] values('a', 'b', 'c');

select currval('serial');

serial being the default index on [tablename]

The statement works fine from the command line, however, when executing via
jdbc, I'm getting no results back (null pointer).

Has anyone experienced this and have a solution?

Regards,
Craig May

Enth Dimension
http://www.enthdimension.com.au



pgsql-sql by date:

Previous
From: Philip Warner
Date:
Subject: Re: how can I mirror a postgres database
Next
From: Bruce Momjian
Date:
Subject: Re: question on diagnostics