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/