On Fri, 2012-11-30 at 23:41 +0000, ke...@omniti.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7716
> Logged by: Keith Fiske
> Email address: ke...@omniti.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?
My guess is that it's to prevent someone from dropping a trigger created
by someone else.
I agree that it's inconsistent. I'm not sure why they added the separate
"TRIGGER" privilege in the first place, but it was done more than 10
years ago.
Regards,
Jeff Davis
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
