On Tue, Sep 11, 2007 at 09:15:56PM -0700, Tena Sakai wrote:
> But there's a problem, for which I hope you have
> more wisdom. The reason why I tried that query
> is because someone tried the same thing via odbc
> from pc quering postgres database and got the
> same error ("out of memory").
>
> What can a pc user do? Anything?
Tell the user that he/she should use an appropiate WHERE clause. You
might also consider adding more swap to the machine. Then it will go
horribly slow, but it will work.
HTH,
Tino.
--
www.spiritualdesign-chemnitz.de
www.lebensraum11.de
Tino Schwarze * Parkstraße 17h * 09120 Chemnitz
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
