Re: Need help on triggers - postgres 9.1.2 - Mailing list 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@iol.ie