Re: isNullable()

From: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: Tomisaw Kityñski <cromax(at)id(dot)pl>
Subject: Re: isNullable()
Date: 2001-09-15 13:42:41
Message-ID: 6am6qt4a4j5cq0dm9tm4cusheknf41e0jf@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-patches

On Fri, 14 Sep 2001 17:53:50 +0200, you wrote:
>could someone tell me, please, do I have any chance to get
>proper implementation of above method in JDBC (1.1+) soon?

This is a volunteer project. You don't "get", you "bring" :-)

>Current "return 1" works fine on most tables, however it seems
>to be a little bit incorrect with some of them ;)

ResultSetMetaData.isNullable() 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.

I propose to change it to return
ResultSetMetaData.columnNullableUnknown until someone comes up
with a real implementation.

Any objections?

Regards,
René Pijlman <rene(at)lab(dot)applinet(dot)nl>

In response to

  • isNullable() at 2001-09-14 15:53:50 from Tomisław Kityński

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-09-15 19:43:58 Re: isNullable()
Previous Message Dave Thompson 2001-09-15 10:36:07 default fetch size

Browse pgsql-patches by date

  From Date Subject
Next Message Rene Pijlman 2001-09-15 19:43:58 Re: isNullable()
Previous Message Bruce Momjian 2001-09-14 17:46:37 Re: Bytea string operator support