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:[EMAIL PROTECTED] 
Sent: Thursday, February 15, 2007 12:55 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. 

"" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

Reply via email to