7.0beta3 is fixed in this area.
> ============================================================================
> 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)
>
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
