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-16 19:36:33
Message-ID: 200109161936.f8GJaXM12596@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

> 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: Peter EisentrautDate: 2001-09-16 23:16:40
Subject: Re: PSQL NLS Support (Russian)
Previous:From: Tom LaneDate: 2001-09-16 16:37:38
Subject: Re: attribute names & typecast/psql default port

pgsql-jdbc by date

Next:From: Justin CliftDate: 2001-09-16 19:38:38
Subject: Re: Need help with JDBC driver. Problem, - getExportedKeys =
Previous:From: Bruce MomjianDate: 2001-09-16 19:36:16
Subject: Re: UpdateableResultSet patch (not finished yet!)

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