Postgres Pro
Downloads
Home   >   mailing lists

Re: why not type casting by default in prepared statements? - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: why not type casting by default in prepared statements?
Date
Msg-id 18505.1037463614@sss.pgh.pa.us
Whole thread Raw
In response to why not type casting by default in prepared statements?  (Harald Krake <harald@krake.de>)
Responses Re: why not type casting by default in prepared statements?  (Harald Krake <harald@krake.de>)
List pgsql-jdbc
Tree view 
Harald Krake <harald@krake.de> writes:
> But now I'm wondering whether there are any good reasons
> not to type cast by default?

This has been suggested, and rejected, repeatedly.  It's not a good
idea to apply a driver-side band-aid to mask a server-side problem;
especially not when the driver does not have adequate information to
fix the problem properly.  (In other words, any driver-side solution
will fix some queries and break others.)

There will be a real solution in the backend someday soon, perhaps 7.4.

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Harald Krake
Date:
Subject: why not type casting by default in prepared statements?
Next
From: "Felipe Schnack"
Date:
Subject: REPOST: inserting default values