I am trying to delete the newly created trigger and procedure in Postgresql and get this error.

I tried to follow mana and make the current user the owner of the database with which I work. Although he, like, was the owner. it says how. Just fed to give all the rights as stated here.

The SQL to remove looks like this:

DROP TRIGGER IF EXISTS update_params ON XXX CASCADE;

Help me figure out what could be the matter?

  • one
    Does the current user own the table XXX, how does the error message hint? ( \dt XXX in psql) - Egor Rogov
  • Yes, I wrote that I made it the owner. Although, on the other hand, I do not know how to check if he really is the owner. - Razzwan
  • Yes, I looked. I was convinced. The current user is the owner. - Razzwan
  • one
    And I wrote how to check: \dt XXX in psql. Alternatively, you can try to say drop trigger ... restrict and see if there are suddenly any dependencies. And yes, if the problem is reproduced, then it would be nice to see the script. - Egor Rogov
  • And, everything, the problem was that first it was necessary to remove the procedure that the trigger caused. It is strange that before this was a similar error and was solved by the reverse sequence of deletions. First the trigger, then the procedure. Now that's the opposite. It would be necessary to figure out what is the difference. - Razzwan

1 answer 1

The sequence of deletion is important. It helped to first remove the procedure, and then the trigger.