[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

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)