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
