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
---
catp
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/plp
ls leak 1-3M per call.
The same leak occurs when I've tried the same code writte on plperl, so
it doesn't seem that the effect is related to plpgsql.
--
Sincerely,
Dmitry Karasik
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
e should be
corresponding spi_exec_prepared/spi_whatever/spi_fetchrow_prepared. If I
have time, I'll look into implementing these, but again, I'd rather wait
until the patch is committed. When 8.1 is scheduled for release?
--
Sincerely,
Dmitry Karasik
-
plan( $x);
return $rv->{rows}[0]->{datum};
$$ LANGUAGE plperl;
--
Thanks,
Dmitry Karasik
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
e for including into -devel.
--
Thanks,
Dmitry Karasik
---
catpipe Systems ApS
*BSD solutions, consulting, development
www.catpipe.net
+45 7021 0050
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Seq Scan on queues (cost=1.00..10016.15 rows=1 width=161)
Filter: ((username ~~ 'a'::text) AND (hostname ~~ 'b'::text))
(2 rows)
# \d queues
...
username | text | not nu
