Re: executing prepared select, missing RowDescription info - Mailing list pgsql-hackers

From Tom Lane
Subject Re: executing prepared select, missing RowDescription info
Date
Msg-id 20332.1082306971@sss.pgh.pa.us
Whole thread Raw
In response to executing prepared select, missing RowDescription info  (Kris Jurka <books@ejurka.com>)
Responses Re: [HACKERS] executing prepared select, missing RowDescription info
List pgsql-hackers
Kris Jurka <books@ejurka.com> writes:
> When executing a prepared select statement, the returned RowDescription
> protocol message does not have any information for the table oid or column
> position.  Running the equivalent select without prepare provides this
> information, so I don't see why the act of preparing and executing the
> statement removes this valuable data.  Any insight on why it isn't there 
> or how to fix it?

Fixing this would be a tad messy, because the information is not
propagated up through a utility-statement Portal.  I guess I would ask
why you're using EXECUTE at all; it's considerably less efficient than
invoking the prepared statement via the protocol-level operation for
doing so (Bind, then Execute).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Remove MySQL Tools from Source?
Next
From: Tom Lane
Date:
Subject: Re: Regression from 7.3 to 7.4