Re: v9.1, DROP TRIGGER IF EXISTS behaving oddly - Mailing list pgsql-general

From Adrian Klaver
Subject Re: v9.1, DROP TRIGGER IF EXISTS behaving oddly
Date
Msg-id 5696E83D.20202@aklaver.com
Whole thread Raw
In response to v9.1, DROP TRIGGER IF EXISTS behaving oddly  ("Williamson, Michael" <Michael.Williamson@tamucc.edu>)
List pgsql-general
On 01/13/2016 03:25 PM, Williamson, Michael wrote:

Ccing list
>>
>> Is that happening on all triggers you are trying to DROP, or just
>> this one?
>
> All, consistently.
>>
>> If just this one, you might want to check to see if the trigger was
>> created with a quoted mixed case name and therefore needs to have
>> the
>> exact case quoted when used in the DROP TRIGGER. Something else to
>> look
>> at is whether there is more then one customer table and you need to
>> schema qualify the name.
>>
>
> The triggers are all being defined in unquoted lowercase.  Also, these
> triggers happen call functions, but I doubt that is relevant.

So is the below the actual error you are getting:

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

>
> Michael
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Code of Conduct: Is it time?
Next
From: Sachin Srivastava
Date:
Subject: Re: Function error