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 allow inserts,
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,
