Group: pgsql.general


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