Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo.

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-15 20:31:40
Message-ID: D730FF7CEDDCA64483F9E99D999A158BD34D41@qxvcexch01.ad.quovadx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Thanks Tom. I used to rely on the PQftype() to determine if the OIDs
stored in that result field are pointing to large objects or not. If
they are large objects, I used to fetch them using lo_* API.
Now since PQftype() returns type oid for type lo columns, how will I
identify if a result column contains large objects or not? One way I can
think of is to use PQftable() and PQftablecol() and then query the type
of the table column from pg_attribute. Would this be the correct way? Is
there a better and easier way to identify the data to be lo?

Thanking you in advance.
Unmesh

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, February 15, 2007 12:55 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.

"" <churi(at)roguewave(dot)com> writes:
> Description: libpq: PQftype() on a lo type result column
returns Oid
> of type oid instead of Oid of type lo.

This is an expected change: type "lo" isn't an independent datatype
anymore, just a domain over OID.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-02-16 02:15:05 Re: BUG #3012: Wrong JOIN order when a JOIN depends on result from a LEFT JOIN.
Previous Message Tom Lane 2007-02-15 19:54:49 Re: BUG #3015: libpq: PQftype() on a lo type result column returns Oid of type oid instead of Oid of type lo.