Data type for oid

"Rod MacNeil" <rmacneil-6hjaaxo62fi/[email protected]> Tue, 30 Aug 2005 16:44:59 -0000
Newsgroups gmane.comp.python.db.pypgsql.user
Message-ID <[email protected]>
Hi All,

I'm using pyPgSQL 2.4 postgres 7.4.7 on fedora core 3.

I have a question about the data type returned in cursor.description =
when oid is included in the select.

When I run a query like "select oid, field1,field2 from mytable where =
field2=3D'x'".

cursor.description says the oid column is type 'rowid' if there are =
result rows, but if there are no result rows it says the type is 'blob'.

Is this a bug?

Rod MacNeil


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D NOTE:
This e-mail message is intended only for the named recipient(s) above
and may contain information that is privileged, confidential and/or
exempt from disclosure under applicable law. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this e-mail message.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D



-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf