Re: Need help on triggers - postgres 9.1.2 - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Need help on triggers - postgres 9.1.2
Date
Msg-id 20140522125958.GB4797@hermes.hilbert.loc
Whole thread Raw
In response to Re: Need help on triggers - postgres 9.1.2  (Khangelani Gama <kgama@argility.com>)
List pgsql-general
On Thu, May 22, 2014 at 02:48:48PM +0200, Khangelani Gama wrote:

> > CREATE OR REPLACE FUNCTION check_center_changes() RETURNS TRIGGER AS
> > $center_changed$
> >
> > BEGIN
> >
> >         IF (TG_OP = 'UPDATE') THEN
> >             INSERT INTO center_changed SELECT c_cde, now();

PostgreSQL probably refuses to take wild guesses where
"c_cde" might come from. You need to tell it.

Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


pgsql-general by date:

Previous
From: Igor Neyman
Date:
Subject: Re: Need help on triggers - postgres 9.1.2
Next
From: Khangelani Gama
Date:
Subject: Re: Need help on triggers - postgres 9.1.2