pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedcurrval() problem
3+ messages / 3 participants
[nested] [flat]
* currval() problem
@ 2000-11-29 01:16 tony <tony@uickarate.com>
0 siblings, 1 reply; 3+ messages in thread
From: tony @ 2000-11-29 01:16 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: currval() problem
@ 2000-11-29 09:37 Peter Mount <petermount@maidstone.gov.uk>
0 siblings, 0 replies; 3+ messages in thread
From: Peter Mount @ 2000-11-29 09:37 UTC (permalink / raw)
To: 'tony' <tony@uickarate.com>; pgsql-interfaces
How are you accessing currval(). Can you post an example?
currval() is implemented in the backend, so there should be no difference
between how its returned and how any other value is returned, so it might be
how you are calling it thats not working.
Peter
--
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council
> -----Original Message-----
> From: tony [mailto:tony@uickarate.com]
> Sent: Wednesday, November 29, 2000 1:16 AM
> To: pgsql-interfaces
> Subject: [INTERFACES] currval() problem
>
>
> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: currval() problem
@ 2000-12-01 08:53 Marko Kreen <marko@l-t.ee>
parent: tony <tony@uickarate.com>
0 siblings, 0 replies; 3+ messages in thread
From: Marko Kreen @ 2000-12-01 08:53 UTC (permalink / raw)
To: tony <tony@uickarate.com>; +Cc: pgsql-interfaces
On Tue, Nov 28, 2000 at 08:16:08PM -0500, tony wrote:
> 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??
does this help?
con.setAutoCommit(false);
--
marko
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-12-01 08:53 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-11-29 01:16 currval() problem tony <tony@uickarate.com>
2000-12-01 08:53 ` Marko Kreen <marko@l-t.ee>
2000-11-29 09:37 RE: currval() problem Peter Mount <petermount@maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox