Re: table and column information from cursor?

John DeSoi <desoi(at)pgedit(dot)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