[GENERAL] Memory exhausted on DELETE.

2004-10-24 Thread jbi130
I have a table with about 1,400,000 rows in it. Each DELETE cascades to about 7 tables. When I do a 'DELETE FROM events' I get the following error: ERROR: Memory exhausted in AllocSetAlloc(84) I'm running a default install. What postgres options to I need to tweak to get this delete to work

[GENERAL] Connecting using an existing socket (libpq).

2004-01-18 Thread jbi130
I have a 3 tier client/server application where the client connection to the server which then uses PostgreSQL. I'd like to extend the client to have direct access to PostgreSQL but do not want to open up postgresql to the internet. So, I'd like to tunnel the libpq connection over the existing se