Crash (maybe related to temp tables)

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