The following bug has been logged on the website:
Bug reference: 7716
Logged by: Keith Fiske
Email address: keith(at)omniti(dot)com
PostgreSQL version: 9.2.1
Operating system: Any
Description:
This is documented in the DROP TRIGGER section of the documentation, but it
doesn't seem to make any sense. If a role has permission to create a
trigger, why can that same role not have the same permissions to drop it,
even if that role doesn't own the table?