General Bug Report: backend closes with aggregate functions on views

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Richi Plana
Your email address : richip(at)mozcom(dot)com

Category : runtime: back-end: SQL
Severity : serious

Summary: backend closes with aggregate functions on views

System Configuration
--------------------
Operating System : SMP Intel/Linux 2.2.0, Sparc/Solaris 2.6

PostgreSQL version : 6.4.2

Compiler used : pgcc-1.1.1 and egcs-1 (for Sparc)

Hardware:
---------
1) SparcStation 20 (50MHz processor), 300+MB RAM, SCSI harddisks
2) Dual Pentium-II 400 (N440BX-based motherboard), 512MB RAM, SCSI harddisk

Versions of other tools:
------------------------
flex-2.5.4, gmake

--------------------------------------------------------------------------

Problem Description:
--------------------
It seems the pg backend disconnects a connection when a user performs an aggregate function on a view. In one instance, doing so killed the backend.
I can't seem to duplicate killing the backend, but is this proper behavior for the backend?

--------------------------------------------------------------------------

Test Case:
----------
create table a (b char(20) not null, c char(10) not null, d int, primary key (b, c));
create view d as select b,sum(d) from a group by b;
select max(sum) from d;

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------