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
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. |