Postgresql insert trigger does not work

Question

New row is added to table A and i need trigger which will automatically insert row in table B after row has been inserted in table A.

CREATE FUNCTION insertblocked (
)
RETURNS trigger AS
$body$
BEGIN
    INSERT INTO tableB (blocked.id,blocked.number,blocked.date)
    VALUES (new.id,new.prefix,now())
    RETURN NEW;
END
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER;

CREATE TRIGGER insertblocked
  AFTER INSERT 
  ON public.tableA FOR EACH ROW 
  EXECUTE PROCEDURE insertblocked();

Please help and advise, why is sql compiler returning and error

QUERY: INSERT INTO blocked (blocked.id,blocked.number,blocked.date) VALUES ( $1 , $2 ,now()) RETURN $3

Denis de Bernardy · Accepted Answer · 2014-04-22 09:59:24Z

2

You're missing a semi-column ; at the end of your insert statement.

answered Apr 22, 2014 at 9:59

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql insert trigger does not work

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related