Re: table and column information from cursor?

John DeSoi  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