v9.1, DROP TRIGGER IF EXISTS behaving oddly

From: "Williamson, Michael" <Michael(dot)Williamson(at)tamucc(dot)edu>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: v9.1, DROP TRIGGER IF EXISTS behaving oddly
Date: 2016-01-13 22:14:33
Message-ID: 1452723272.26175.11.camel@tamucc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm attempting to drop a trigger that may or may not exist, so am using
the "IF EXISTS" clause.  This works fine for tables, views, functions,
domains, and types, but for some reason seems to be ignored for
triggers.  I'd expect to see more about this online if it were a bug,
so I'm thinking I may be missing something obvious.

Example:
DROP TRIGGER IF EXISTS udf_customer_update_trigger ON customer;

Expected Output:
NOTICE:  trigger "udf_customer_update_trigger" does not exist, skipping

Observed Output:
ERROR:  relation "udf_customer_update_trigger" does not exist

Environment:
CentOS 6.6
postgresql91-server-9.1.14-1PGDG.rhel6.x86_64

Thanks,
Michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-01-13 22:24:11 Re: v9.1, DROP TRIGGER IF EXISTS behaving oddly
Previous Message oleg yusim 2016-01-13 22:08:47 Re: Data Packaging/Data Unpacking