Re: SPI_ERROR_CONNECT within pl/pgsql, PG 8.4

Hi,

> This is a normal interbackend communication signal. You need to
> configure gdb to ignore SIGUSR2 (ie, pass it on and not stop execution).
> Probably SIGUSR1 too.

Done.

Here's the result:

Breakpoint 1, 0x000000000054aec0 in SPI_connect ()
(gdb) bt
#0 0x000000000054aec0 in SPI_connect ()
#1 0x00002afdffd243c2 in plpgsql_call_handler () from
/usr/local/pgsql/lib/plpgsql.so
#2 0x00000000005331f7 in ExecMakeFunctionResult ()
#3 0x0000000000534f1a in ExecEvalExprSwitchContext ()
#4 0x00000000005919e4 in evaluate_expr ()
#5 0x0000000000592e69 in simplify_function ()
#6 0x000000000059354e in eval_const_expressions_mutator ()
#7 0x0000000000556d70 in expression_tree_mutator ()
#8 0x0000000000593414 in eval_const_expressions_mutator ()
#9 0x00000000005934e2 in eval_const_expressions_mutator ()
#10 0x00000000005566bd in expression_tree_mutator ()
#11 0x000000000059332d in eval_const_expressions_mutator ()
#12 0x0000000000556d70 in expression_tree_mutator ()
#13 0x000000000059332d in eval_const_expressions_mutator ()
#14 0x000000000059436f in eval_const_expressions ()
#15 0x00000000005862a1 in preprocess_expression ()
#16 0x00000000005889cf in subquery_planner ()
#17 0x0000000000588f63 in standard_planner ()
#18 0x00000000005cc6b1 in pg_plan_query ()
#19 0x00000000005cc76e in pg_plan_queries ()
#20 0x000000000066a522 in RevalidateCachedPlan ()
#21 0x00002afdffd27e12 in exec_eval_expr () from
/usr/local/pgsql/lib/plpgsql.so
#22 0x00002afdffd28122 in exec_eval_boolean () from
/usr/local/pgsql/lib/plpgsql.so
#23 0x00002afdffd2d927 in exec_stmt_if () from /usr/local/pgsql/lib/plpgsql.so
#24 0x00002afdffd2c3b8 in exec_stmts () from /usr/local/pgsql/lib/plpgsql.so
#25 0x00002afdffd2bb70 in exec_stmt_block () from
/usr/local/pgsql/lib/plpgsql.so
#26 0x00002afdffd2e26f in plpgsql_exec_function () from
/usr/local/pgsql/lib/plpgsql.so
#27 0x00002afdffd2447e in plpgsql_call_handler () from
/usr/local/pgsql/lib/plpgsql.so
#28 0x00000000005331f7 in ExecMakeFunctionResult ()
#29 0x0000000000530157 in ExecProject ()
#30 0x0000000000541dd3 in ExecResult ()
#31 0x000000000052fb86 in ExecProcNode ()
#32 0x000000000052d99f in standard_ExecutorRun ()
#33 0x00000000005cfff4 in PortalRunSelect ()
#34 0x00000000005d11e0 in PortalRun ()
#35 0x00000000005ccfcb in exec_simple_query ()
#36 0x00000000005cdce4 in PostgresMain ()
#37 0x00000000005a50fb in ServerLoop ()
#38 0x00000000005a5c2a in PostmasterMain ()
#39 0x000000000055498e in main ()

Looking forward to your reply !

--
Best,

Frank.