From: | "Unmesh Churi" <churi(at)roguewave(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo. |
Date: | 2007-02-20 23:51:56 |
Message-ID: | D730FF7CEDDCA64483F9E99D999A158BDB5223@qxvcexch01.ad.quovadx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I guess the only option left for 8.2.x then is to PQftable() and
PQftablecol() on the result and then query the pg_attribute to figure
out the type. The penalty would be an additional server round-trip and
query execution per OID type fetched, which may be considerable.
Changing 'lo' back to the independent type for 8.3.x, will help
significantly in increasing performance and reducing complexity. Thank
you.
Unmesh
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Sunday, February 18, 2007 2:59 PM
To: Unmesh Churi
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] BUG #3015: libpq: PQftype() on a lo type result
column returns Oid of type oid instead of Oid of type lo.
Well, we could change type 'lo' back to an independent type as of 8.3,
but I'm not sure that will help you --- 8.1 and 8.2 are doing it as a
domain and we can't retroactively change that situation.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jessica | 2007-02-21 06:00:08 | BUG #3044: what is correct configuration? |
Previous Message | Matt Smith | 2007-02-20 23:50:36 | BUG #3041: Universal Binary Support in Configure |