If one of the contrib modules (int_array_aggregate in contrib/intagg) is
crashing my backend, where's a good place to report a bug or get hints
where to look further?
It seems to work fine on small arrays, but crashes on large ones.
The second query would have put about 500 rows in the aggregate.
Thanks,
Ron
% psql fli fli
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.
[...]
fli=# select str_name,int_array_aggregate(tlid) from tlid_streetnames
where str_name='civic center' and tigerfile=6001 group by str_name;
str_name | int_array_aggregate
--------------+-------------------------------------------
civic center | {125030363,125030026,125030039,125050707}
(1 row)
fli=# select str_name,int_array_aggregate(tlid) from tlid_streetnames
where str_name='main' group by str_name;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
