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

Re: Can PostgreSQL do data type automated casting in

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tjioe Ai Xin <xinxincute(at)gmail(dot)com>
Cc: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>, Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Can PostgreSQL do data type automated casting in
Date: 2005-11-23 11:00:12
Message-ID: 43844BBC.403@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Tjioe Ai Xin wrote:

> How can I make it default to off?

With current drivers you can't. You can try protocolVersion=2 as a 
workaround as suggested elsewhere but that's a bit of a blunt instrument 
really.

> Does the performance of PostgreSQL drop a lot if I change it?
> Especially the speed?

You will have to try it with your particular application to find out. 
Yes, query plans can change, and that may affect performance one way or 
the other.

-O

In response to

pgsql-jdbc by date

Next:From: Tjioe Ai XinDate: 2005-11-23 11:02:32
Subject: Re: Can PostgreSQL do data type automated casting in
Previous:From: Oliver JowettDate: 2005-11-23 10:57:51
Subject: Re: Switching user within connection.

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