Re: v9.1, DROP TRIGGER IF EXISTS behaving oddly

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(dot)klaver(at)aklaver(dot)com