Subject: plpgsql trigger coredumps instance
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/13/2007 8:08:50 PM
Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes:
> I've got a strange situation where instance may crash sometimes on
> pgplsql function call that performs several inserts into tables with
> triggers attached. Are there any known bugs regarding plpgsql and
> triggers in 8.2.5 ? Thanks!
Nope; can you provide a reproducible test case? Or at least a stack
trace?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
Subject: plpgsql trigger coredumps instance
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 12/13/2007 9:05:43 PM
Alex Vinogradovs <AVinogradovs@Clearpathnet.com> writes:
> Not the entire thing was compiled with debugging symbols, here is
> what I get for stack trace:
Not much help. We might get a little further if you recompile with
--enable-debug (and I'd suggest adding --enable-cassert too) and then
get a stack trace next time it happens. But most likely, the most
productive thing to work on is to try to make the crash reproducible.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|