Re:

"bts solutions" <bts_postgresql(at)hotmail(dot)com> writes:
> We have implemented use of cursor in psql.

> + results =3D PQexec(pset.db, "begin work");
> + own_work =3D PQresultStatus(results) =3D=3D PGRES_COMMAND_OK;

I do not believe this works for the case where one is already inside a
transaction block. BEGIN will not report an error, so you'll end up
improperly issuing a COMMIT.

More generally, I'm not happy with having psql issue substantially
different SQL commands than what I gave it. I think it should be the
application's business to use a cursor, not psql's.

regards, tom lane