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

HI,everybody:

recently i found some errors in pg_log when i do some pressure testing,looks
like

 "2013-01-05 21:48:29.870
CST,"postgres","wedding",15850,"172.25.10.28:37100",50e82f2d.3dea,1,"SELECT",2013-01-05
21:48:29 CST,19/80509,0,ERROR,55000,"currval of sequence
""t_wedding_wedding_id_seq"" is not yet defined in this session"
,,,,,,"    SELECT currval('t_wedding_wedding_id_seq')as weddingId
",,,""
2013-01-05 21:48:29.984
CST,"postgres","wedding",15856,"172.25.10.28:37123",50e82f2d.3df0,1,"SELECT",2013-01-05
21:48:29 CST,25/91770,0,ERROR,55000,"currval of sequence
""t_wedding_wedding_id_seq"" is not yet defined in this session"
,,,,,,"    SELECT currval('t_wedding_wedding_id_seq')as weddingId      "


the code is

begin;
        insert into t_wedding(wedding_id,share_id,share_type,user_id,wedding_time)
        select nextval('t_wedding_wedding_id_seq')
        ,#ShareId#,#shareType#,#userId#,#weddingTime#
        <selectKey resultClass="int" keyProperty="weddingId">
            SELECT currval('t_wedding_wedding_id_seq')as weddingId
        </selectKey>
        ;
        COMMIT;

the column wedding_id type is serial + primary key, and i set the sequence
cache from 1 to 50,errors still exists,but reduced。

I use ibatis，but it seems not support returning wedding_id !!!

MY environment:
Postgres 9.1.2
ibatis
pgbouncer ( Transaction mode )
Postgres-9.1-901.jdbc4.jar  as my drive

As i used *begin *  to wrapped it as a transaction, then why zhe errors
still occurs ?





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/currval-of-sequence-xxx-seq-is-not-yet-defined-in-this-session-tp5738893.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.