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.

I just checked to make sure that CURRENT doesn't appear in the current
source as used in rules.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026