Re: Need help on triggers - postgres 9.1.2

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Khangelani Gama <kgama(at)argility(dot)com>, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Need help on triggers - postgres 9.1.2
Date: 2014-05-22 12:53:46
Message-ID: 537DF35A.8070400@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 22/05/2014 13:48, Khangelani Gama wrote:
> Hi
>
> My problem is on two lines, INSERT statements, I get an error saying c_cde
> does not exist
>
> INSERT INTO center_changed SELECT c_cde, now(); - My problem is here: I
> get an error saying c_cde does not exist, I cant how I can give

You need to specify where c_cde is coming from - so OLD.c_cde or
NEW.c_cde (or else SELECT .... FROM... if it's coming from somewhere else).

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Khangelani Gama 2014-05-22 12:55:28 Re: Need help on triggers - postgres 9.1.2
Previous Message Khangelani Gama 2014-05-22 12:48:48 Re: Need help on triggers - postgres 9.1.2