I'm sorry, I forgot to say I had the bug with 8rc3, then installed 8.0.0 and it is still crashing.
On Thu, 27 Jan 2005 10:52:37 -0700, Michael Fuhr <mike@xxxxxxxx> wrote:
[I've Cc'ed pgsql-bugs and set the Reply-To header to that list.]
On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
It seems that contrib/intagg crashes my server : ------------------------------------------------------------------------- select int_agg_final_array(1); server closed the connection unexpectedly
I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on Solaris 9 and FreeBSD 4.11. Here's part of the backtrace from the core dump on FreeBSD:
(gdb) bt
#0 0x285077f4 in ShrinkPGArray (p=0x1) at int_aggregate.c:130
#1 0x28507929 in int_agg_final_array (fcinfo=0xbfbfeb90) at int_aggregate.c:177
#2 0x8106db8 in ExecMakeFunctionResult (fcache=0x83410a0, econtext=0x83411e8,
isNull=0xbfbfecef "\b0ÃÂÂÂK\024\bÂz3\bÃ\003", isDone=0x0) at execQual.c:1042
#3 0x8107583 in ExecEvalFunc (fcache=0x83410a0, econtext=0x83411e8,
isNull=0xbfbfecef "\b0ÃÂÂÂK\024\bÂz3\bÃ\003", isDone=0x0) at execQual.c:1459
#4 0x8108beb in ExecEvalExprSwitchContext (expression=0x83410a0, econtext=0x83411e8,
isNull=0xbfbfecef "\b0ÃÂÂÂK\024\bÂz3\bÃ\003", isDone=0x0) at execQual.c:2781
#5 0x8145353 in evaluate_expr (expr=0x8337ab8, result_type=1007) at clauses.c:2399
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
