Re: [HACKERS] Prepared select

2004-04-20 Thread Cyril VELTER
Result() will do any additional * flushing needed. */ if (pqFlush(conn) < 0) goto sendFailed; /* OK, it's launched! */ conn->asyncStatus = PGASYNC_BUSY; return PQexecFinish(conn); sendFailed: pqHandleSendFailure(conn); return NULL; } - Original Message - From: &quo

Re: [HACKERS] Prepared select

2004-04-20 Thread Robert Turnbull
There are several production issues related to the proposed solution. For example, what happens when the result set exceeds the swap space of the server or client machine? My original question is how to get a cursor from a prepared select so a subset of the result can be returned to the client for

Re: [HACKERS] Prepared select

2004-04-14 Thread Christoph Haller
> > > How can I use a prepared select statement as mentioned in the documentation= > on SQL PREPARE. Preparing the statement is easy, the problem is using the = > plan to get a cursor. My assumption is the SQL OPEN command is not document= > ed or there is some other libpq API to make this happe

[HACKERS] Prepared select

2004-04-02 Thread Robert Turnbull
How can I use a prepared select statement as mentioned in the documentation on SQL PREPARE. Preparing the statement is easy, the problem is using the plan to get a cursor. My assumption is the SQL OPEN command is not documented or there is some other libpq API to make this happen.   Thanks