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

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 (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-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

pgsql-patches by date

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

pgsql-jdbc by date

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

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