CODEWITHSUNDEEP
sqlpostgresqltriggersplpgsql
Hello Laddies
Hello Laddies

Reputation: 21

Postgresql insert trigger does not work

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

Upvotes: 0

Views: 530

Answers (1)

Denis de Bernardy
Denis de Bernardy

Reputation: 78413

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

Upvotes: 2

Related Questions