Re: event trigger API documentation? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: event trigger API documentation?
Date
Msg-id 516F111E.1040708@gmx.net
Whole thread Raw
In response to Re: event trigger API documentation?  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: event trigger API documentation?
List pgsql-hackers
On 4/17/13 3:20 PM, Dimitri Fontaine wrote:
>> It would have been good to have at least one untrusted language with
>> > event trigger support, so that you can hook in external auditing or
>> > logging systems.  With the existing PL/pgSQL support, the possible
>> > actions are a bit limited.
> Well, you do realise that the only information you get passed down to
> the event trigger code explicitely are the event name and the command
> tag, and nothing else, right?

Offhand, that seems about enough, but I'm just beginning to explore.

Chances are, event triggers will end up somewhere near the top of the
release announcements, so we should have a consistent message about what
to do with them and how to use them.  If for now, we say, we only
support writing them in PL/pgSQL, and here is how to do that, and here
are some examples, that's fine.  But currently, it's not quite clear.

Surely you had some use cases in mind when you set out to implement
this.  What were they, and where are we now in relation to them?



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Enabling Checksums
Next
From: Marko Kreen
Date:
Subject: Re: [GENERAL] currval and DISCARD ALL