Re: [GENERAL] Cannot allocate memory for output buffer

2009-11-27 Thread Peter Erickson
Thanks. Out of curiosity, if memory exhaustion was the problem, any idea why the task manager would show that I'm only using 1.2GB of the 3GB of memory? On 11/27/2009 5:15 PM, Tom Lane wrote: Pete Erickson writes: I am looking for some help regarding an python OperationalError that I recent

Re: [GENERAL] Creating a trigger function

2004-04-07 Thread Peter Erickson
Richard Huxton wrote: On Sunday 04 April 2004 20:40, Peter Erickson wrote: Ok, I have determined that i can't do: IF NEW IS NOT NULL -- or -- IF OLD IS NOT NULL and that is what is causing the error. So, with this now known, is there a way to create a trigger & function that will allo

[GENERAL] Creating a trigger function

2004-04-06 Thread Peter Erickson
I am running postgresql 7.4.2 and having problems creating a trigger function properly. I keep getting the following error: ERROR: OLD used in query that is not in rule I have a table called journal_entries with a foreign key to a table called journals. When a entry is added to journal_entries,