Greg Stark wrote: > Well in a way it does. Postgres would get an out-of-memory error from malloc > which it would handle properly and the world would be happy. > > Except not quite, since I think an out of memory error still means that > backend exits instead of just that query failing.
Not at all -- the transaction is aborted, but the backend can continue working perfectly fine. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly