Re: An statement causes postmaster to die

On Sun, 22 Apr 2001, tgl(at)sss(dot)pgh(dot)pa(dot)us wrote:

> Can't tell much of anything from this. Can you provide a gdb backtrace
> from the corefile that the failed backend presumably left? It should be
> in $PGDATA/base/isp/core.

Please ignore my last mail, I've found some documentation.
Starting gdb like:

gdb ~/bin/postgres core

as the PostgreSQL user and getting a backtrace looks like:

(gdb) bt
#0 0x8115eb2 in ri_BuildQueryKeyFull ()
#1 0x8115dc2 in RI_FKey_keyequal_upd ()
#2 0x8096d7c in DeferredTriggerSaveEvent ()
#3 0x8096016 in ExecARUpdateTriggers ()
#4 0x809c617 in ExecReplace ()
#5 0x809c256 in ExecutePlan ()
#6 0x809b8f3 in ExecutorRun ()
#7 0x80eb46a in ProcessQueryDesc ()
#8 0x80eb4d0 in ProcessQuery ()
#9 0x80ea153 in pg_exec_query_dest ()
#10 0x80ea033 in pg_exec_query ()
#11 0x80eaeec in PostgresMain ()
#12 0x80d565a in DoBackend ()
#13 0x80d523a in BackendStartup ()
#14 0x80d45ee in ServerLoop ()
#15 0x80d407c in PostmasterMain ()
#16 0x80ab115 in main ()
#17 0x400fa577 in __libc_start_main () from /lib/libc.so.6
(gdb)

Thanks,

--
Sean