
I'm not sure if  I've reported this  or not...  selecting from a  view
that uses count and group by (when data exists) crashes the back end.

nice to see that I can order by the result of count(*) now :)

brett=> create table a (b text, c text);
CREATE
brett=> create table d (e text, f text);
CREATE
brett=> create view g as select b,count(d.oid) from b,d group by b;       
ERROR:  b: Table does not exist.
brett=> create view g as select b,count(d.oid) from a,d group by b;
CREATE
brett=> select * From g;
b|count
-+-----
(0 rows)

brett=> insert into a values ('foo', 'bar');
INSERT 53151 1
brett=> select * From g;
b|count
-+-----
(0 rows)

brett=> insert into d values ('baz', 'chicken');
INSERT 53152 1
brett=> select * From g;
PQexec() -- Request was sent to backend, but backend closed the channel before responding.
        This probably means the backend terminated abnormally before or while processing the request.
brett=> 

Mon,  9 Mar 1998 20:50:11 -0800 (PST)
Brett McCormick <brett@work.chicken.org>
views with group by/count segfault
> 
> 
> I'm not sure if  I've reported this  or not...  selecting from a  view
> that uses count and group by (when data exists) crashes the back end.
> 
> nice to see that I can order by the result of count(*) now :)

Already in TODO:
	
	* Allow views of aggregate columns


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Tue, 10 Mar 1998 09:10:06 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [BUGS] views with group by/count segfault