Michael Fuhr wrote:
On Tue, Jul 05, 2005 at 04:37:05PM -0400, Tom Lane wrote:
Michael Fuhr <[EMAIL PROTECTED]> writes:
On Tue, Jul 05, 2005 at 09:54:52PM +0200, Hans-Jürgen Schönig wrote:
we have found a bug in CVS head using PL/Perl:
How current is your checkout? Mine's from this morning and I don't
get a crash with the example you posted:
None for me either (trying on a Fedora Core 3 x86 box; don't currently
have plperl built on my other machine). Platform-specific issue maybe?
My platform that works is Solaris 9/sparc with Perl 5.8.7; compiler
is gcc 3.4.2.
Did you get a core dump? If so, can you do a stack trace on it?
I am running FC4 on x86. There is no core dump.
I have compiled it all over again cleanly.
The last elog is never reached so something seems to go wrong inside the
SQL call ...
CREATE OR REPLACE FUNCTION trig_func() RETURNS trigger AS '
# select the current transaction id
elog(NOTICE, "trigger starting ...");
$sql = "SELECT transaction, pid FROM pg_locks "
. "WHERE transaction IS NOT NULL AND pid =
pg_backend_pid() ";
elog(NOTICE, "sql: $sql");
my $rv = spi_exec_query($sql);
elog(NOTICE, "looking for transactions ...");
I don't know what it is yet as it seemed to work with 8.0.3.
Interesting to see that nodody else has similar problems ...
regards,
hans
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
