How to drop multiple triggers in a PostgreSQL 9.1 DB

Question

I'm trying to remove multiple triggers but getting a SQL error:

PG::Error: ERROR:  syntax error at or near ";"
LINE 1:     DROP TRIGGER rr_admin_reports;

Here is the sql I'm executing in rails:

sql = <<-SQL
  DROP TRIGGER rr_admin_reports;
  DROP TRIGGER rr_apps;
  DROP TRIGGER rr_attachments;
SQL

Is there a way to easily delete a long list of triggers? Thanks

Floris Velleman · Accepted Answer · 2013-08-02 09:57:34Z

14

DROP TRIGGER rr_admin_reports ON yourTable;

Quote from PostgreSQL documentation:

The DROP TRIGGER statement in PostgreSQL is incompatible with the SQL standard. In the SQL standard, trigger names are not local to tables, so the command is simply DROP TRIGGER name.

http://www.postgresql.org/docs/7.4/static/sql-droptrigger.html

edited Aug 2, 2013 at 9:57

answered Jan 4, 2013 at 20:08

Floris Velleman

4,9084 gold badges32 silver badges47 bronze badges

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

2 Comments

AnApprentice Over a year ago

Is there a way to say DROP TRIGGER IF EXISTS?

Floris Velleman Over a year ago

Yes use: DROP TRIGGER IF EXISTS rr_admin_reports ON yourTable; :)

Collectives™ on Stack Overflow

How to drop multiple triggers in a PostgreSQL 9.1 DB

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related