Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?
Date: 2007-03-02 00:16:18
Message-ID: 26671.1172794578@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Dave Cramer <pg(at)fastcrypt(dot)com> writes:
> On 1-Mar-07, at 7:06 PM, Tom Lane wrote:
>> At least in this particular case, leaving the parameter type as
>> UNKNOWN
>> would have worked as the OP wishes. I dunno if that would break other
>> cases though.

> This means you have to leave all parameter types as UNKNOWN. What's
> the point of having parameter types at all ?

No, only the ones you do not have any knowledge about. The OP's
complaint is basically that the driver is forcing the parameter type
to "varchar" on the basis of nothing whatsoever.

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-03-02 01:15:25 Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?
Previous Message Dave Cramer 2007-03-02 00:09:17 Re: Inserting "null" not working (Sun App Server, Postgres, EJB3)?