John DeSoi <desoi@xxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
