> After some time I decided to drop the event trigger. The command is executed > successfully (DROP EVENT TRIGGER <name> CASCADE) > I double checked by querying the information_schema.triggers (the list is > empty) > > But every time I try to execute a DDL operation, I encounter an error saying > that DDL function was called. > The error was saying the operation failed because awsdms_intercept_ddl() > function.
Maybe you're dropping the event trigger in one database, but it still exist in other databases. For example, if you originally created it in template1 and it got propagated by CREATE DATABASE into some new one, then if you drop it from template1 it'll still exist in the databases you created later.
-- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ ¡Ay, ay, ay! Con lo mucho que yo lo quería (bis) se fue de mi vera ... se fue para siempre, pa toíta ... pa toíta la vida ¡Ay Camarón! ¡Ay Camarón! (Paco de Lucía)
