Memory exhaustion - Mailing list pgsql-sql

From Srikanth Rao
Subject Memory exhaustion
Date
Msg-id 20010404184509.25903.qmail@web6303.mail.yahoo.com
Whole thread Raw
List pgsql-sql
marketingbyoffice is a view. 

I start the postmaster, then issue the following query
in psql console. It goes to sleep forever:-)

Why? 
The log is as follows:

------log ----- 
010404.13:49:14.612  [1352] StartTransactionCommand
010404.13:49:14.612  [1352] query: SELECT * INTO TEMP
TABLE marketingbylocation FROM marketingbyoffice;
010404.13:49:14.624  [1352] ProcessQuery
010404.13:52:28.691  [1352] FATAL 1:  Memory exhausted
in AllocSetAlloc()
010404.13:52:32.568  [1352] AbortCurrentTransaction


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/


pgsql-sql by date:

Previous
From: jkakar@expressus.com
Date:
Subject: Need to do an ALTER TABLE.
Next
From: Tom Lane
Date:
Subject: Re: Need to do an ALTER TABLE.