On Thu, 18 Oct 2007, Andrei Ilitchev wrote:
> I created a table with identity:
> CREATE TABLE MAN (ID SERIAL, NAME VARCHAR(40), PRIMARY KEY (ID))
> then through jdbc connection inserted a row into the table,
> then attempted to select pk value back through the same jdbc connection using
> currval - that failed with "not yet defined in this session" exception.
>
Any chance you have two man_id_seq sequences in different schemas? The
table insert might use one and the direct currval/nextval calls might use
another?
Kris Jurka