Re: Having a little trouble with TRIGGERS - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Having a little trouble with TRIGGERS
Date
Msg-id 200101241827.NAA08794@candle.pha.pa.us
Whole thread Raw
In response to Re: Having a little trouble with TRIGGERS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> "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

pgsql-general by date:

Previous
From: "Egon Schmid (@work)"
Date:
Subject: Re: Postgres-Book from addison-wesley?
Next
From: Guillaume Lémery
Date:
Subject: Very bad performance on a query