Re: Need help on triggers - postgres 9.1.2

[Karsten Hilbert <Karsten.Hilbert@xxxxxxx>]

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