Re: Having a little trouble with TRIGGERS

"Brendan Green" <bgreen@simtap.com.au> writes:
> The problem is that when I try to insert a record into the table, I get the
> following error:
> ERROR:  CURRENT used in non-rule query.
> I've been banging my head against a brick wall for the past few days.  I
> *think* that it has something to do with a problem of "new" being aliased
> somehow with "CURRENT", but I don't know!!!  Save me from insanity!

Actually I think CURRENT is an alias for OLD; it may be that the select
from a table named OLD is confusing the thing.

            regards, tom lane