Error creating trigger..?

Question

SQL

Can you see what's wrong with the trigger?

create trigger updater
AFTER INSERT
ON done_cars
for each row
update table2 set table2.counting=table2.counting+1 where table2.workshop_id=new.number;

here is the error:

ERROR: ОШИБКА: ошибка синтаксиса (примерное положение: "update")
LINE 5: update table2 set table2.counting=table2.counting+1 where ta...

Answer 1

Of course, it is not necessary to specify the DBMS, they are all the same ...
Apparently, postgres. If so, please read the documentation . Do you see an opportunity to write any DML queries directly in CREATE TRIGGER?
In postgres, all trigger actions are performed through a special function (links to examples in different languages ​​- https://www.postgresql.org/docs/13/triggers.html ) that the trigger should call.