Re: isNullable()

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rene Pijlman <rene(at)lab(dot)applinet(dot)nl>
Cc: pgsql-patches(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org, Tomis³aw Kityñski <cromax(at)id(dot)pl>
Subject: Re: isNullable()
Date: 2001-09-17 15:56:08
Message-ID: 200109171556.f8HFu9K11034@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-patches


Patch applied. Thanks.

> Attached is a patch that fixes ResultSetMetaData.isNullable() in
> the JDBC driver.
>
> 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.
>
> The patch simply changes the return value to
> ResultSetMetaData.columnNullableUnknown. This is until someone
> comes up with a real implementation of course.
>
> On Fri, 14 Sep 2001 17:53:50 +0200, Tomisaw Kity?ski wrote:
> >Hello there,
> >
> >could someone tell me, please, do I have any chance to get
> >proper implementation of above method in JDBC (1.1+) soon?
> >
> >Current "return 1" works fine on most tables, however it seems
> >to be a little bit incorrect with some of them ;)
>
>
> Regards,
> Ren? Pijlman <rene(at)lab(dot)applinet(dot)nl>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russ McBride 2001-09-17 19:18:15 Re: newbie question: . . .
Previous Message Bruce Momjian 2001-09-17 15:54:52 Re: Patch for Statement Escape Processing problems

Browse pgsql-patches by date

  From Date Subject
Next Message John Summerfield 2001-09-17 18:36:20 Re: SQLCODE==-209
Previous Message Vianen, Jeroen van 2001-09-17 07:59:07 Re: Fix for broken JDBC's getColumn() (take 2)