currval

From: Craig May <craig(dot)may(at)s2(dot)enthdimension(dot)com(dot)au>
To: pgsql-sql(at)postgresql(dot)org
Subject: currval
Date: 2000-10-02 04:56:20
Message-ID: 20001002045620.B6334@s2.enthdimension.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

  • plpgsql at 2000-12-08 20:51:30 from Jie Liang

Browse pgsql-sql by date

  From Date Subject
Next Message Emils Klotins 2000-10-02 05:38:08 Q: spinlock on Alpha? (PG7.0.2)
Previous Message Bruce Momjian 2000-10-02 04:17:13 Re: question on diagnostics