Geoffrey <esoteric(at)3times25(dot)net> writes:
> Program terminated with signal 11, Segmentation fault.
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> in pl_exec.c
> #0 exec_stmt (estate=0xfeff8a90, stmt=0x0) at pl_exec.c:928
> #1 0x0083f005 in exec_stmts (estate=0xfeff8a90, stmts=0x90fa9e0)
> at pl_exec.c:903
> #2 0x0083f4f2 in exec_stmt_if (estate=0xfeff8a90, stmt=0x90fab78)
> at pl_exec.c:1139
It seems you've got a corrupt "compiled statements" data structure for
a plpgsql trigger function. Offhand this does not look like any of the
known post-7.4.7 bug fixes. Can you show us the source code for that
trigger?
regards, tom lane