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.comViaMezzera 29/A - 20030 - Seveso (MI) - Italy
-------------------------------------------------------------------------------