Received: from ns.crystaldonuts.com ([38.194.228.45]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAT2GKt94337 for ; Tue, 28 Nov 2000 21:16:21 -0500 (EST) (envelope-from tony@uickarate.com) Received: (qmail 23930 invoked from network); 29 Nov 2000 02:16:21 -0000 Received: from unknown (HELO tonydesktop) (64.148.169.10) by 38.194.228.45 with SMTP; 29 Nov 2000 02:16:21 -0000 Message-ID: <001a01c059a1$f9ffc6f0$32fea8c0@tonydesktop> From: "tony" To: "pgsql-interfaces" References: <3A1B11B4.1FA5AC73@uickarate.com> <3A1B16D4.76F6B49C@10happythings.com> Subject: currval() problem Date: Tue, 28 Nov 2000 20:16:08 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200011/284 X-Sequence-Number: 321 Hello I have a problem with currval() through JDBC. My nextval() updates the counter of sequences, but currval() returns no value even after I call nextval(). Both work fine when I try them through psql. Have you encountered this problem before?? Tony