Skip site navigation (1) Skip section navigation (2)

Re: Can PostgreSQL do data type automated casting

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Tjioe Ai Xin <xinxincute(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Can PostgreSQL do data type automated casting
Date: 2005-11-22 00:48:02
Message-ID: 1132620482.5937.14.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-jdbc
Drat.  I didn't realize that it's not possible to detect a bad statement
without invalidating the current transaction, that's definitely a no-
starter.

-- Mark

On Mon, 2005-11-21 at 19:28 -0500, Kris Jurka wrote:
> 
> On Mon, 21 Nov 2005, Mark Lewis wrote:
> 
> > Here's a thought; do you think it's feasible to detect cases where the
> > protocol=3 driver throws an error due to invalid or ambiguous typing
> > issues when the protocol=2 driver would just do the expected thing?
> >
> > Instead of throwing the error back to the user, could the driver then
> > issue a 'describe statement' call, use the result to disambiguate the
> > parameter settings, and re-issue the call?  It increases the overhead
> > but only for the error cases, and the result could be cached to avoid
> > repeating that overhead.
> >
> 
> There a number of problems with the fallback approach.  First, since we've 
> got a server error that will necessitate the transaction be rolled back so 
> we'd have to establish a savepoint before every statement.  Then you'd 
> have to detect an error condition as being related to type resolution 
> which isn't really clear.  Even if this did work for people it certainly 
> wouldn't be optimal because you could end up doing a lot more work, 
> parsing twice and establishing and rolling back to savepoint, without 
> knowing it.  Your application would look like it was working, but it's 
> certainly not how you want it to.
> 
> Kris Jurka
> 

In response to

pgsql-jdbc by date

Next:From: Dave CramerDate: 2005-11-22 03:59:06
Subject: Re: Can PostgreSQL do data type automated casting in
Previous:From: Kris JurkaDate: 2005-11-22 00:28:00
Subject: Re: Can PostgreSQL do data type automated casting in prepared

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group