Re: [GENERAL] Problem trying to load trigger

Thanks to everyone who answered. Getting used to PostGres's unique syntax can take time getting used to. Best Regards Michael Gould "Tom Lane" wrote: > Michael Gould writes: >> CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$ >> BEGIN > >> IF(TG_WHEN = 'BEFORE')

Re: [GENERAL] Problem trying to load trigger

Michael Gould writes: > CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$ > BEGIN > IF(TG_WHEN = 'BEFORE') THEN > IF(TG_OP = 'INSERT') THEN > NEW.createdatetime := current_timestamp > NEW.createuser := current_user You've forgotten to end these stateme

Re: [GENERAL] Problem trying to load trigger

On 2 Aug 2009, at 19:08, Michael Gould wrote: CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$ BEGIN IF(TG_WHEN = 'BEFORE') THEN IF(TG_OP = 'INSERT') THEN NEW.createdatetime := current_timestamp NEW.createuser := current_user ELSIF (TG_OP = 'UPDATE')

[GENERAL] Problem trying to load trigger

CREATE OR REPLACE FUNCTION iss.accessor_trigger() RETURNS "trigger" AS $$ BEGIN IF(TG_WHEN = 'BEFORE') THEN IF(TG_OP = 'INSERT') THEN NEW.createdatetime := current_timestamp NEW.createuser := current_user ELSIF (TG_OP = 'UPDATE') THEN INSERT into iss.auditaccessor SELECT '