> Hm, I'm wondering if the toast-vs-index bug could be relevant. Could > you try 8.1 branch tip? Or at least apply this patch: > > http://archives.postgresql.org/pgsql-committers/2005-11/msg00439.php
Hmm, the patch mentioned for ExecMain.c won't apply to my base version, so I went for a fresh cvs checkout of REL8_1_STABLE instead. It took a while, since Slack's version of Bison is too old and I needed to get a more recent one. Anyway, the restore still fails, backtrace against cvs now looks like this: #0 0x0825382c in CopySnapshot (snapshot=0x0) at tqual.c:1301 1301 newsnap = (Snapshot) palloc(sizeof(SnapshotData) + (gdb) where #0 0x0825382c in CopySnapshot (snapshot=0x0) at tqual.c:1301 #1 0x081467db in fmgr_sql (fcinfo=0xbff21cb0) at functions.c:319 #2 0x0814017c in ExecMakeFunctionResult (fcache=0x84ce4a8, econtext=0x84ce900, isNull=0xbff21f2b "$\033=\b", isDone=0x0) at execQual.c:1095 #3 0x08142796 in ExecEvalExprSwitchContext (expression=0x84d04f4, econtext=0x0, isNull=0xbff21f2b "$\033=\b", isDone=0x0) at execQual.c:2864 #4 0x08189f23 in evaluate_expr (expr=0x84ce4a8, result_type=23) at clauses.c:2646 #5 0x0818b9b9 in simplify_function (funcid=291943, result_type=23, args=0x84c60c0, allow_inline=1 '\001', context=0xbff22140) at clauses.c:2260 #6 0x0818beba in eval_const_expressions_mutator (node=0x84c5e44, context=0xbff22140) at clauses.c:1305 #7 0x0818a68d in expression_tree_mutator (node=0x84c4688, mutator=0x818bce0 <eval_const_expressions_mutator>, context=0xbff22140) at clauses.c:3473 #8 0x0818bf1d in eval_const_expressions_mutator (node=0x84c477c, context=0xbff22140) at clauses.c:1335 #9 0x0818c501 in eval_const_expressions_mutator (node=0x84c6004, context=0xbff22140) at clauses.c:2030 #10 0x0818cb05 in eval_const_expressions (node=0x84c47a8) at clauses.c:1211 #11 0x0822ff93 in RelationGetIndexPredicate (relation=0x442fb9f4) at relcache.c:2790 #12 0x080cb4cf in BuildIndexInfo (index=0x442fb9f4) at index.c:900 #13 0x080fec96 in analyze_rel (relid=293056, vacstmt=0x4422628c) at analyze.c:257 #14 0x0813734b in vacuum (vacstmt=0x4422628c, relids=0x4421d89c) at vacuum.c:476 #15 0x0819365f in autovacuum_do_vac_analyze (relids=0x44224154, dovacuum=0 '\0', doanalyze=1 '\001', freeze=0 '\0') at autovacuum.c:907 #16 0x0819401d in AutoVacMain (argc=0, argv=0x0) at autovacuum.c:681 #17 0x08194366 in autovac_start () at autovacuum.c:170 #18 0x0819a101 in ServerLoop () at postmaster.c:1269 #19 0x0819b292 in PostmasterMain (argc=3, argv=0x833b8a0) at postmaster.c:943 #20 0x0815bf3e in main (argc=3, argv=0x833b8a0) at main.c:256 Again and still, relation 293056 referred to in frame 13 is the purchaseorder_line table. -- Best, Frank. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
