contrib module intagg crashing the backend - Mailing list pgsql-general

From Ron Mayer
Subject contrib module intagg crashing the backend
Date
Msg-id Pine.LNX.4.58.0503221717390.13920@greenie.cheapcomplexdevices.com
Whole thread Raw
Responses Re: contrib module intagg crashing the backend  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general

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.
!>


pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: OSX, ODBC and Office 2004
Next
From: "Randy Samberg"
Date:
Subject: postgres oracle emulation question