Re: A question relative to creating an audit table - Mailing list pgsql-general

From Andrei Zhidenkov
Subject Re: A question relative to creating an audit table
Date
Msg-id 7BF2891E-FA4E-49CC-8477-A0537572CD84@n26.com
Whole thread Raw
In response to A question relative to creating an audit table  (stan <stanb@panix.com>)
Responses Re: A question relative to creating an audit table  (stan <stanb@panix.com>)
List pgsql-general
Why not to pass TG_TABLE_SCHEMA and TG_TABLE_NAME in its arguments?

> On 27. Feb 2020, at 22:28, stan <stanb@panix.com> wrote:
> 
> I ma considering setting up a function, and triggers to put a record in an
> audit table when certain tables are altered. I pretty much think I know how
> to do this, with one exception.
> 
> Can a function, called by a trigger, determine what table it was called
> for?
> 
> -- 
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
>                         -- Benjamin Franklin
> 
> 




pgsql-general by date:

Previous
From: stan
Date:
Subject: A question relative to creating an audit table
Next
From: Adrian Klaver
Date:
Subject: Re: A question relative to creating an audit table