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