Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF
Date
Msg-id 10801.1193404182@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF  (Sebastien FLAESCH <sf@4js.com>)
Responses Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF
Re: PostgreSQL 8.3, libpq and WHERE CURRENT OF
List pgsql-hackers
Tree view 
Sebastien FLAESCH <sf@4js.com> writes:
> Does a simple PQPrepare() with a SELECT statement not create a cursor on
> the server side?

No.  A prepared statement is just a query plan, not a query-in-progress.

The Bind/Execute messages sent by PQexecPrepared create something akin
to a cursor, but libpq doesn't expose any API for fetching one row at a
time in that context, so there's no way to use the "current row" anyway.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: PANIC caused by open_sync on Linux
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: [PERFORM] 8.3beta1 testing on Solaris