User who created a trigger is not able to drop it

From: "Ali (dot)" <ali-spb(at)hotmail(dot)com>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: User who created a trigger is not able to drop it
Date: 2017-08-16 21:46:21
Message-ID: HE1PR10MB01863BE04E6E37BAE8B7F1FAE7820@HE1PR10MB0186.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

This looks similar to the BUG #7716, reported back in 2012: "Only owner can drop trigger?"

According to current documentation it is not a bug but feature, though it would be more consistent if system could additionally track the trigger owner so that he can clean after himself when trigger is no longer required.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tatsuo Ishii 2017-08-16 23:13:04 Re: [HACKERS] Replication to Postgres 10 on Windows is broken
Previous Message Tom Lane 2017-08-16 16:56:49 Re: BUG #14781: server process was terminated by signal 11: Segmentation fault