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

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 (view raw or flat)
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

pgsql-jdbc by date

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

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