Re: server side cursors update & delete,

On 02/09/2016 01:31 AM, Vardhan wrote:
> Hi,
>
> The section   '39.7.3.3. UPDATE/DELETE WHERE CURRENT OF' of
> http://www.postgresql.org/docs/9.2/static/plpgsql-cursors.html
> specifies the syntax as:
>
>    UPDATE table SET ... WHERE CURRENT OF cursor;
>    DELETE FROM table WHERE CURRENT OF cursor;
>
> Is there a way to generate these syntax for update & delete ?
>
> Right now, if i get the error that .execute() can't be called more than once !

Have you looked at?:

http://initd.org/psycopg/docs/usage.html#server-side-cursors

and

http://initd.org/psycopg/docs/connection.html#connection.cursor
>
> --
> TIA
> Vardhan
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com