Re: Calling stored function that returns a cursor from a libpq program - Mailing list pgsql-novice

From Tom Lane
Subject Re: Calling stored function that returns a cursor from a libpq program
Date
Msg-id 7631.1250177438@sss.pgh.pa.us
Whole thread Raw
In response to Calling stored function that returns a cursor from a libpq program  (Mazen Abdel-Rahman <saba.mazen@gmail.com>)
Responses Re: Calling stored function that returns a cursor from a libpq program  (Mazen Abdel-Rahman <saba.mazen@gmail.com>)
List pgsql-novice
Mazen Abdel-Rahman <saba.mazen@gmail.com> writes:
> I am trying to use a stored functions that returns a CURSOR in a C
> program that uses that libpq library.

It looks like you've just hardwired an assumption about what the name of
the cursor will be.  It'd be better to pay attention to the name
returned by the function.

It also looks like you're not bothering to check that the BEGIN command
succeeded.  If it didn't for some reason, that could explain the
failure.

            regards, tom lane

pgsql-novice by date:

Previous
From: Mazen Abdel-Rahman
Date:
Subject: Calling stored function that returns a cursor from a libpq program
Next
From: Mazen Abdel-Rahman
Date:
Subject: Re: Calling stored function that returns a cursor from a libpq program