| From: | Mark Lewis <mark(dot)lewis(at)mir3(dot)com> |
|---|---|
| To: | Kris Jurka <books(at)ejurka(dot)com> |
| Cc: | Andrei Ilitchev <andrei(dot)ilitchev(at)oracle(dot)com>, pgsql-jdbc(at)postgresql(dot)org, Marina Vatkina <Marina(dot)Vatkina(at)Sun(dot)COM> |
| Subject: | Re: Fw: postgresql experts please help |
| Date: | 2007-10-18 18:10:14 |
| Message-ID: | 1192731014.6447.87.camel@archimedes |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Thu, 2007-10-18 at 13:41 -0400, Kris Jurka wrote:
>
> On Thu, 18 Oct 2007, Mark Lewis wrote:
>
> > You haven't disabled JDBC autocommit for this connection. That means
> > that each statement gets executed in a separate transaction.
> >
> > Since currval is only valid within the scope of a single transaction,
> > and you're executing your "select currval" from a separate transaction,
> > that's why you can't see it.
> >
>
> False. currval maintains state across transactions:
Oops. I knew that-- not thinking straight this morning I guess :) I
wish mailing list archives had take-backs.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrei Ilitchev | 2007-10-18 18:47:05 | Re: Fw: postgresql experts please help |
| Previous Message | Kris Jurka | 2007-10-18 18:05:40 | Re: AbstractJdbc2Array - another patch |