Where is a mistake? - Mailing list pgsql-interfaces

From Alexandr Listopad
Subject Where is a mistake?
Date
Msg-id Pine.BSF.4.10.10005261724210.27113-100000@Eagle.ZGIA.zp.ua
Whole thread Raw
List pgsql-interfaces
CREATE VIEW v1 AS SELECT n.net AS net,                       n.sh_desc AS net_name,                       count(s.ip)
AStotal_q        sum(s.bytes)/1024 AS Kb                       FROM zgia_nets n,                       squid_logs s
                 WHERE network_sub(s.ip,n.net)                       AND
date_eq(dt::date,'24-05-2000')                      AND                       s.peer_stat != 'NONE'
 GROUP BY net,net_name                       ORDER BY Kb;
 

stats=> select t1.net,t1.net_name,t1.total_q,t1.total_q/sum(t2.total_q) from v1 t1,
v1 t2 group by 1,2,3;

pqReadData() -- backend closed the channel unexpectedly.       This probably means the backend terminated abnormally
  before or while processing the request.
 
We have lost the connection to the backend, so further processing is
impossible.  Terminating.


where is a mistake? or is it a bug?

I have PGSQL v 6.5.3.


--Laa.



pgsql-interfaces by date:

Previous
From: Herbert Rabago Ambos
Date:
Subject: Re: importing from other dbases
Next
From: Tom Lane
Date:
Subject: Re: Postgresql 7.0 JDBC exceptions - broken connections ?