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

Re: [HACKERS] JDBC pg_description update needed for CVS tip

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, Barry Lind <barry(at)xythos(dot)com>, pgsql-jdbc(at)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, jeroen(dot)van(dot)vianen(at)satama(dot)com
Subject: Re: [HACKERS] JDBC pg_description update needed for CVS tip
Date: 2001-09-10 14:55:16
Message-ID: 200109101455.f8AEtGe20861@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbcpgsql-patches
Patch applied.  Thanks.

> On Fri, 07 Sep 2001 01:34:46 -0400, Tom Lane wrote:
> >there is still an unpatched reference to pg_description in 
> >getColumns(), in both jdbc1 and jdbc2.
> 
> This was introduced by Jeroen's patch (see
> http://fts.postgresql.org/db/mw/msg.html?mid=1032468). Attached
> is a patch that returns getColumns() to using "select
> obj_description()" instead of direct access to pg_description,
> as per the request by Tom. 
> 
> I've incorporated Jeroen's fix to left outer join with
> pg_attrdef instead of inner join, so getColumns() also returns
> columns without a default value.
> 
> I have, however, not included Jeroen's attempt to combine
> multiple queries into one huge multi-join query for better
> performance, because:
> 1) I don't know how to do that using obj_description() instead
> of direct access to pg_description
> 2) I don't think a performance improvement (if any) in this
> method is very important
> 
> Because of the outer join, getColumns() will only work with a
> backend >= 7.1. Since the conditional coding for 7.1/7.2 and
> jdbc1/jdbc2 is already giving me headaches I didn't pursue a
> pre-7.1 solution.
> 
> Regards,
> Ren? Pijlman <rene(at)lab(dot)applinet(dot)nl>

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://www.postgresql.org/search.mpl

-- 
  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-hackers by date

Next:From: Joe ConwayDate: 2001-09-10 15:01:19
Subject: Re: Toast, Text, blob bytea Huh?
Previous:From: Haroldo StengerDate: 2001-09-10 14:28:39
Subject: Re: Abort state on duplicated PKey in transactions

pgsql-patches by date

Next:From: Bruce MomjianDate: 2001-09-10 15:07:10
Subject: Re: Patch to add bytea support to JDBC
Previous:From: Bruce MomjianDate: 2001-09-10 14:54:29
Subject: Re: Fix JDBC test suite, set/get transaction isolation level

pgsql-jdbc by date

Next:From: Bruce MomjianDate: 2001-09-10 15:07:10
Subject: Re: Patch to add bytea support to JDBC
Previous:From: Bruce MomjianDate: 2001-09-10 14:54:29
Subject: Re: Fix JDBC test suite, set/get transaction isolation level

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