Add more tests on event triggers

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Add more tests on event triggers
Date: 2015-02-25 08:24:03
Message-ID: alpine.DEB.2.10.1502250911440.10787@sto
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Here are some more tests for event triggers, especially about new features
introduced recently in 296f3a6053844089bc533630fffafaba8f016384.

Check that COMMENT, GRANT and REVOKE do trigger some events.

The patch also check some more error cases: SQL function, functions with
declared arguments, arguments passed to the trigger, event trigger on
global objects (ROLE, TABLESPACE, DATABASE).

I have left out "SECURITY LABEL" which would require a special security
label provider. Note that they do not seem to be tested at all anyway:-(
The "security_label.sql" really tests that all fails when no plugin is
available. If some actual tests are added to security label some day, I
think that event triggers about them should be tested there.


Attachment Content-Type Size
event-test-1.diff text/x-diff 6.3 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Jeremy Harris 2015-02-25 09:05:30 Re: Abbreviated keys for text cost model fix
Previous Message Jim Nasby 2015-02-25 07:58:31 Re: Proposal : REINDEX xxx VERBOSE