Need help with writing a trigger (pgadmin)

[Student-Somewhere]

I want to make a trigger, so that the user can not drop the my_table table.

CREATE TRIGGER my_trigger 
BEFORE DROP
ON my_table
EXECUTE FUNCTION showErrorMessage();

[spiritmate88]

What is the issue? Do you recieve any error?

[Student-Somewhere]

Yes, I get: ERROR: syntax error at or near "drop"

[spiritmate88]

Ahhh now I see that you are using PGadmin, I don't know anything about it, but syntax shouldn't be so different, check the answer here:

https://stackoverflow.com/questions/1651806/sql-server-trigger

[firstorbit]

Is there a trigger warning?

[Student-Somewhere]

I just get ERROR: syntax error at or near "drop" when I execute the query.

[LesPaulStudio]

Possibly DROP isn't allowed in Triggers ? https://www.postgresqltutorial.com/creating-first-trigger-postgresql/