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

From Tom Lane
Subject Re: Having a little trouble with TRIGGERS
Date
Msg-id 12651.980352855@sss.pgh.pa.us
Whole thread Raw
In response to Having a little trouble with TRIGGERS  ("Brendan Green" <bgreen@simtap.com.au>)
Responses Re: Having a little trouble with TRIGGERS  (Bruce Momjian <pgman@candle.pha.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.

            regards, tom lane

pgsql-general by date:

Previous
From: "David Wall"
Date:
Subject: Re: MySQL has transactions
Next
From: Tom Lane
Date:
Subject: Re: Out of overflow pages. Out of luck.