From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | contrib module intagg crashing the backend |
Date: | 2005-03-23 01:21:32 |
Message-ID: | Pine.LNX.4.58.0503221717390.13920@greenie.cheapcomplexdevices.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs 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.
!>
From | Date | Subject | |
---|---|---|---|
Next Message | David B. | 2005-03-23 01:59:27 | can install pg - it's unbelievable |
Previous Message | Cade Cairns | 2005-03-22 19:13:41 | BUG #1558: memory leak in libpq connectDBStart() |
From | Date | Subject | |
---|---|---|---|
Next Message | Randy Samberg | 2005-03-23 01:51:06 | postgres oracle emulation question |
Previous Message | Vernon | 2005-03-23 01:05:16 | Command prompt window (8.0) |