Cannot drop trigger getting error in PostgreSQL

Question

I am learning PostgreSQL after python. I follow tutorialspoint.com website.

There is no problem until i create a trigger and it works like a charm..

But when I tried to delete (i.e., drop) the trigger, i get the following error.

DROP TRIGGER example_trigger;
ERROR:  syntax error at or near ";"
LINE 1: DROP TRIGGER example_trigger;
                                    ^

I am not sure why do I get this error. Help me please. Is it common or am I going wrong?

user330315 · Accepted Answer · 2016-06-02 10:21:54Z

8

drop trigger example_trigger on table_name;

answered Jun 2, 2016 at 10:21

user330315

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

Comments

Super Kai - Kazuya Ito · Accepted Answer · 2023-12-30 23:00:25Z

0

I created my_t trigger on test table as shown below:

CREATE TRIGGER my_t AFTER UPDATE ON test
FOR EACH ROW EXECUTE FUNCTION my_func();

Then, I tried to drop my_t trigger as shown below:

DROP TRIGGER my_t;

But, I got the same error below:

ERROR: syntax error at or near ";"
LINE 1: DROP TRIGGER my_t;

So, I set test table with ON as shown below, then I could drop my_t trigger without error. *The doc explains how to drop a trigger in detail:

               -- ↓ ↓ ↓ ↓
DROP TRIGGER my_t ON test;

In addition, the SQL below with RESTRICT is exactly same as the SQL above:

DROP TRIGGER my_t ON test RESTRICT;

answered Dec 30, 2023 at 23:00

42.8k23 gold badges259 silver badges258 bronze badges