Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC
Date
Msg-id 17514.1390975308@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC  (David Johnston <polobo@yahoo.com>)
Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-general
Tree view 
Craig Ringer <craig@2ndquadrant.com> writes:
> I just want us to allow, by default, implicit casts FROM text (not TO
> text) using the input function for all PostgreSQL's validated
> non-standard types (and XML due to limited deployment of SQL/XML support
> in client drivers).

Sorry, that is *just* as dangerous as implicit casts to text were.
It would bite a different set of queries, but not any less painfully.

I have about zero sympathy for ORMs that aren't willing to address
this issue properly.  Yeah, it might be less than trivial, but that
doesn't mean that the right answer is to create semantic hazards
on the server side.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC
Next
From: David Johnston
Date:
Subject: Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC