Re: Need help on triggers - postgres 9.1.2

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help on triggers - postgres 9.1.2
Date: 2014-05-22 12:59:58
Message-ID: 20140522125958.GB4797@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Khangelani Gama 2014-05-22 13:01:23 Re: Need help on triggers - postgres 9.1.2
Previous Message Igor Neyman 2014-05-22 12:55:29 Re: Need help on triggers - postgres 9.1.2