[HACKERS] Prepared queries and portals

2004-06-10 Thread Cyril VELTER
While adapting an application to make use of the new protocol, I've faced one problem. I cannot execute a prepared query and fetch the result in several time. The multiple fetch is accessible with cursor in SQL but I haven't found any way to execute a prepared query in a cursor. The docum

Re: [HACKERS] Prepared queries and portals

2004-03-04 Thread Cyril VELTER
"Tom Lane" <[EMAIL PROTECTED]> writes: > "Cyril VELTER" <[EMAIL PROTECTED]> writes: > > so I've modified libpq to handle the case by adding to functions : > > > PQexecPreparedPortal(conn,stmtName,portalName,nParams,paramValues,paramlengt > > h,paramFormats,resultFormat,maxrows); > > > and > > >

Re: [HACKERS] Prepared queries and portals

2004-03-03 Thread Tom Lane
"Cyril VELTER" <[EMAIL PROTECTED]> writes: > so I've modified libpq to handle the case by adding to functions : > PQexecPreparedPortal(conn,stmtName,portalName,nParams,paramValues,paramlengt > h,paramFormats,resultFormat,maxrows); > and > PQfetchPortal(conn,portalName,maxrows) > PQe