Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC
Date: 2014-01-28 23:24:41
Message-ID: 20140128232440.GR8796@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 28, 2014 at 02:55:03PM -0800, Mike Christensen wrote:

> I'd be curious as to what types of bugs were caused by these implicit
> casts..

Typically, they were cases when there was an ambiguity that the
programmer didn't understand, causing applications to blow up in
surprising and wonderful ways.

There are things you can do if you're really prepared for the gun
aimed at your feet. Since you can create casts in Postgres, you can
actually add back many of the implicit casts yourself.

> Such as implicitly cast iff the intention is not ambiguous

I think if the developers could write code that read minds, they'd be
working on more profitable enterprises ;-)

Best,

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Christensen 2014-01-28 23:36:28 Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC
Previous Message Mike Christensen 2014-01-28 22:55:03 Re: PostgreSQL specific datatypes very confusing for beginners who use wrappers around JDBC