There is no solid test scenario, as it doesn't happen every time,
and I couldn't reproduce it by manually running the queries.
Not the entire thing was compiled with debugging symbols, here is
what I get for stack trace:
#0 0x005492a9 in spi_printtup ()
#1 0x0054a0bc in SPI_execute_plan ()
#2 0x0008692d6655 in plpgsql_compile ()
from /usr/local/lib/postgresql/plpgsql.so
#3 0x0008692d8953 in plpgsql_exec_trigger ()
from /usr/local/lib/postgresql/plpgsql.so
#4 0x0008692d7493 in plpgsql_compile ()
from /usr/local/lib/postgresql/plpgsql.so
#5 0x0008692d86ce in plpgsql_exec_trigger ()
from /usr/local/lib/postgresql/plpgsql.so
#6 0x0008692d7083 in plpgsql_compile ()
from /usr/local/lib/postgresql/plpgsql.so
#7 0x0008692dad0d in plpgsql_exec_function ()
from /usr/local/lib/postgresql/plpgsql.so
#8 0x0008692cf00e in plpgsql_call_handler ()
from /usr/local/lib/postgresql/plpgsql.so
#9 0x0052f2b7 in ExecMakeFunctionResult ()
#10 0x00533e90 in ExecProject ()
#11 0x00542f61 in ExecResult ()
#12 0x0052d657 in ExecProcNode ()
#13 0x0052b6a1 in ExecutorRun ()
#14 0x005e01e4 in PortalSetResultFormat ()
#15 0x005e09bf in PortalRun ()
#16 0x005dc47b in pg_parse_query ()
#17 0x005de243 in PostgresMain ()
#18 0x005a2239 in ClosePostmasterPorts ()
#19 0x005a400c in PostmasterMain ()
#20 0x005553f6 in main ()
the system is FreeBSD 6.2 AMD64 running on Xeon 64 bit.
On Thu, 2007-12-13 at 20:08 -0500, Tom Lane wrote:
Alex Vinogradovs [EMAIL PROTECTED] 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 4: Have you searched our list archives?
http://archives.postgresql.org/