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:[EMAIL PROTECTED] Sent: Sunday, February 18, 2007 2:59 PM To: Unmesh Churi Cc: pgsql-bugs@postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
