Re: A question relative to creating an audit table

From: Andrei Zhidenkov <andrei(dot)zhidenkov(at)n26(dot)com>
To: stan <stanb(at)panix(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: A question relative to creating an audit table
Date: 2020-02-27 21:30:15
Message-ID: 7BF2891E-FA4E-49CC-8477-A0537572CD84@n26.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)panix(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-02-27 21:35:57 Re: A question relative to creating an audit table
Previous Message stan 2020-02-27 21:28:47 A question relative to creating an audit table