Re: Problem asking columns allowing NULL values

From: Peter Royal <proyal(at)pace2020(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Problem asking columns allowing NULL values
Date: 2003-04-10 19:54:53
Message-ID: 4C476444-6B8E-11D7-9D38-000393B61B56@pace2020.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thursday, April 10, 2003, at 03:13 PM, . wrote:
> "This method is currently unimplemented and always returns
> ResultSetMetaData.columnNullable. This is obviously incorrect
> when a column is defined with NOT NULL or PRIMARY KEY. And we
> have to think of check constraints, views, functions etc.
>
> This patch simply changes the return value to
> ResultSetMetaData.columnNullableUnknown. This is until someone
> comes up with a real implementation of course."
>
> I'll apreciate if somebody could tell me if someone are working on
> this. If
> not, well, I'm not a Java guru, but perhaps I could help.

If you need a solution today, I recommend using the DatabaseMetaData to
get information on the table, it will properly tell you about column
nullability.
-pete

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-04-11 00:43:54 Re: Problem asking columns allowing NULL values
Previous Message . 2003-04-10 19:13:14 Re: Problem asking columns allowing NULL values