books@ejurka.com (Kris Jurka) wrote in message news:<Pine.BSO.4.56.0410181515590.5115@leary.csoft.net>...
> On Mon, 18 Oct 2004, Tomas wrote:
>
> > How can you get metadata from a resultset that is returned from a
> > stored function ?
>
> You need to be running with autocommit off for this to work at all. This
> is not just a metadata problem. The problem is that cursors are closed at
> commit, which in auto commit mode is before the results can even be
> fetched from it. It could definitely use a better error message, the 8.0
> driver gives "ERROR: cursor "<unnamed portal 1>" does not exist", but
> that's still not very good.
>
> Kris Jurka
Thank you Kris for your answer.
I was using the 7.4 version of the driver since the PostgreSQL version
I am using is 7.4.5 but now I tested the 8.0 driver and then the
metadata seems to work. Regarding the 7.4 driver it did not help to
change the autocommit.
/ Tomas
