Thread

1. views with group by/count segfault

   Brett McCormick <brett@work.chicken.org> — 1998-03-10T04:50:11Z

   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=> 
   
   

2. Re: [BUGS] views with group by/count segfault

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-10T14:10:06Z

   > 
   > 
   > 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)