Re: Having a little trouble with TRIGGERS

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Having a little trouble with TRIGGERS
Дата
Msg-id 200101241827.NAA08794@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Having a little trouble with TRIGGERS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Egon Schmid (@work)"
Дата:
Сообщение: Re: Postgres-Book from addison-wesley?
Следующее
От: Guillaume Lémery
Дата:
Сообщение: Very bad performance on a query