Re: currval of sequence xxx_seq is not yet defined in this session?

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: kenyon <lqchenzjut(at)sina(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: currval of sequence xxx_seq is not yet defined in this session?
Date: 2013-01-10 00:21:33
Message-ID: 50EE098D.9010002@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/08/2013 05:58 PM, kenyon wrote:
> Thanks for your reply!
>
> yeath,I quite accept your opinion,once i guess the drive adds savepoint
> between the two SQL，but not sure

Off hand I would say the drive has nothing to do with it. The issue
would seem to be that as originally written ibatis was issuing two
queries in different sessions. This meant the query trying to fetch the
currval could not find it because the sequence nextval() was happening
in another session.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message felix 2013-01-10 00:25:54 Re: How can I detect if a schema exists?
Previous Message Scott Marlowe 2013-01-10 00:15:15 Re: Error: absolute path not allowed