Re: Backend crash with user defined aggregate - Mailing list pgsql-general

From Tom Lane
Subject Re: Backend crash with user defined aggregate
Date
Msg-id 8148.1127523943@sss.pgh.pa.us
Whole thread Raw
In response to Backend crash with user defined aggregate  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: Backend crash with user defined aggregate
List pgsql-general
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> I tried making an aggregate function that concatenates
> any non-null strings it encounters, as shown below.
> The function works fine on small tables; but when I run
> it on one of my larger tables it seems to me that it
> crashes the backend - though I don't see anything obvious
> in the log.

I tried this example in CVS tip and didn't see any particular misbehavior.
What PG version are you running?  Does EXPLAIN show that the query is
being done with a group or hash aggregation?  What do you have sort_mem
set to?

            regards, tom lane

pgsql-general by date:

Previous
From: hildebardo@prodigy.net.mx
Date:
Subject: question about to return two diferent tables from a function
Next
From: Matthew Peter
Date:
Subject: Re: array_dims array_lower/upper distance