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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
