============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Marinos J. Yannikos
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Celeron
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.13
PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3
Compiler used (example: gcc 2.8.0) : gcc 2.91.60
Please enter a FULL description of your problem:
------------------------------------------------
Backend crashes at some queries involving views of aggregate queries.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
create table a (x float, id text);
create view b as select min(x),id from a group by id;
insert into a values (0,'x');
select a0.* from a a0, b b0 where b0.id=a0.id and a0.x=b0.min;
(crash)
*******************************************************************************
QUERY: select a0.* from a a0, b b0 where b0.id=a0.id and a0.x=b0.min;
*******************************************************************************
press return to continue ..
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.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
(no)
