Re: Batch INSERT failing with error 22P02 - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Batch INSERT failing with error 22P02
Date
Msg-id Pine.BSO.4.64.0709240835350.10797@leary.csoft.net
Whole thread Raw
In response to Re: Batch INSERT failing with error 22P02  (Kris Jurka <books@ejurka.com>)
Responses Re: Batch INSERT failing with error 22P02
List pgsql-jdbc

On Fri, 21 Sep 2007, Kris Jurka wrote:

> So the fix is probably to check that we aren't setting type information from
> stale results, but this is a pretty complicated area, so I'd like to study it
> a little more.
>

OK, I've committed a fix for 8.1, 8.2, and 8.3-dev to the CVS repository.
It simply checks that the describe results match the currently parsed
query before applying them.  There is still an optimization to be made
here, in that we don't need to describe at all if the Query has all the
needed type informtion already, but I'll leave that for later.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Eric Faulhaber
Date:
Subject: Re: Batch INSERT failing with error 22P02
Next
From: Eric Faulhaber
Date:
Subject: Re: Batch INSERT failing with error 22P02