Re: [GENERAL] psql crashing - don't know why

2009-08-10 Thread Martijn van Oosterhout
On Mon, Aug 10, 2009 at 11:04:24AM +1200, Brent Wood wrote: > Hi... > > I have a view across 3 tables, total some 5m rows. > > I can extract parts of the view, entire rows, with a where clause > (eg: select * from view where cell_id=10;) > > If I try to select the entire view (eg: select *

Re: [GENERAL] psql crashing - don't know why

2009-08-09 Thread Shoaib Mir
On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe wrote: > On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood wrote: > > Hi... > > > > I have a view across 3 tables, total some 5m rows. > > > > I can extract parts of the view, entire rows, with a where clause > > (eg: select * from view where cell_id=10;

Re: [GENERAL] psql crashing - don't know why

2009-08-09 Thread Scott Marlowe
On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood wrote: > Hi... > > I have a view across 3 tables, total some 5m rows. > > I can extract parts of the view, entire rows, with a where clause > (eg: select * from view where cell_id=10;) > > If I try to select the entire view (eg: select * from view;) it