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 r...@iol.ie -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
