Thread: table and column information from cursor?

I was wondering if there is some way I'm missing to get the table and
column information from a cursor. If I fetch from a cursor, the table
OID and column number values are 0 in the row description. If I execute
the same query directly without a cursor, the row description has the
correct values for table OID and column number. I'm using the v3
protocol via a socket with PostgreSQL 8.0.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

John DeSoi <desoi@pgedit.com> writes:
> I was wondering if there is some way I'm missing to get the table and
> column information from a cursor. If I fetch from a cursor, the table
> OID and column number values are 0 in the row description. If I execute
> the same query directly without a cursor, the row description has the
> correct values for table OID and column number. I'm using the v3
> protocol via a socket with PostgreSQL 8.0.

Fixed in CVS tip.  Turned out that prepared statements had the same
issue, that is in

    PREPARE foo AS SELECT ...;
    EXECUTE foo;

the row description returned by EXECUTE wouldn't tell you where the
columns came from.

            regards, tom lane