[HACKERS] prepared queries in plpgsql

2005-10-23 Thread Dmitry Karasik
Hi all, I've finalized the patch that does prepared queries in plperl, tests included, it's at http://www.karasik.eu.org/software/patches/pgsql-plperl.patch I'd like to ask if there's a chance that it might be included in 8.2 -- Sincerely, Dmitry Karasik --- catpipe Systems ApS *BSD s

Re: [HACKERS] prepared queries in plperl

2005-10-06 Thread Dmitry Karasik
Hi Dmitry! On 27 Sep 05 at 16:16, "Dmitry" (Dmitry Karasik) wrote to "Andrew Dunstan": Andrew> Meanwhile, I will observe that this very desirable feature needs Andrew> an interface with spi_fetchrow() I re-worked the patch ( http://www.karasik.eu.org/misc/plperl.diff ) and now there's

Re: [HACKERS] prepared queries in plperl

2005-09-27 Thread Dmitry Karasik
Andrew> We need to examine the names being used on our spi functions - I'm Andrew> not sure there is sufficient consistency about them. Yes, but I'd rather wish the patch committed before that, because otherwise I would be forced to rework the code again, after the namespace is finally stabiliz

Re: [HACKERS] prepared queries in plperl

2005-09-27 Thread Andrew Dunstan
Dmitry Karasik said: > > Hello, > > I've posted before a patch that enables prepared queries in plperl, and > now, after a while, as it seems working as expected, I'd like to ask if > it would be a reasonable thing to commit in into -devel? The patch > against the latest cvs is at http://www.karasi

[HACKERS] prepared queries in plperl

2005-09-27 Thread Dmitry Karasik
Hello, I've posted before a patch that enables prepared queries in plperl, and now, after a while, as it seems working as expected, I'd like to ask if it would be a reasonable thing to commit in into -devel? The patch against the latest cvs is at http://www.karasik.eu.org/misc/plperl.diff . The

Re: [HACKERS] prepared queries in plperl

2005-07-15 Thread Abhijit Menon-Sen
At 2005-07-15 17:17:01 +0200, [EMAIL PROTECTED] wrote: > > I needed prepared queries in plperl, but there's none, so I baked > a patch that defines two extra perl functions, spi_prepare and > spi_exec_prepared Oh. I've been working on the same functionality this week following a conversation with

[HACKERS] prepared queries in plperl

2005-07-15 Thread Dmitry Karasik
Hi, I needed prepared queries in plperl, but there's none, so I baked a patch that defines two extra perl functions, spi_prepare and spi_exec_prepared, and it seems to work more-less ok. The patch is here, http://www.karasik.eu.org/misc/plperl.diff but it's not in any way a final patch; havin

[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

[HACKERS] prepared queries

2004-02-05 Thread Andrew Dunstan
The current release of DBD::Pg contains this in the CHANGES file: - $dbh->prepare() rewrites the SQL statement into an internal form, striping out comments and whitespace, and if PostgreSQL > 7.3 takes the stripped statement and passes that to Postgres' PREPAR