Thanks , I will try that -----Original Message----- From: Raymond O'Donnell [mailto:rod@xxxxxx] Sent: Thursday, May 22, 2014 2:54 PM To: Khangelani Gama; Andrew Sullivan; pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] Need help on triggers - postgres 9.1.2 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@xxxxxx CONFIDENTIALITY NOTICE The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.
