
Hi,

Using PostgreSQL 6.5.2 just compiled on a RedHat 6.0 box.

------------------------
BEGIN;

SELECT username,count(*) AS nsessions INTO TEMP TABLE active_nsessions FROM
active GROUP BY username

SELECT username,count(*) AS nlinks INTO TEMP TABLE active_nlinks FROM active
GROUP BY username,port,server

SELECT * FROM active,counters,users,active_nsessions,active_nlinks WHERE
active.username=users.username AND active.username=counters.username AND
active.username=active_nsessions.username AND
active.username=active_nlinks.username

pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
------------------------

Active table is empty with this structure:

CREATE TABLE active
(
 username               varchar(32),
 server                 varchar(35),
 pop                    varchar(20),
 remAddr                varchar(30),
 port                   varchar(15),
 service                varchar(10),
 addr                   inet,
 privilege              int2,
 authenmethod           int2,
 authentype             int2,
 authenservice          int2,
 starttime              datetime,
 taskid                 int4,
 callerid               varchar(21),
 callednumber           varchar(21),
 rxrate                 int4,
 txrate                 int4,

 bytesin                int8,
 bytesout               int8,
 paksin                 int8,
 paksout                int8,

 watchdog_timeout       timespan,
 watchdog_lastreset     datetime,

 logout_requested       bool,
 logout_request_time    datetime
);

Bye!

-- 
 Daniele

-------------------------------------------------------------------------------
 Daniele Orlandi - Utility Line Italia - http://www.orlandi.com
 Via Mezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------

Mon, 20 Sep 1999 18:54:56 +0200
Daniele Orlandi <daniele@orlandi.com>
Crash (maybe related to temp tables)