Re: Does trigger only accept functions?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: veem v <veema0000(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Does trigger only accept functions?
Date: 2024-06-11 11:33:44
Message-ID: Zmg2GIso2Lb4r_2m@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jun 11, 2024 at 12:47:14AM +0530, veem v wrote:
> to be called from ~50 triggers? or any other better approach exists to
> handle this?

pgaudit extension?

Or just write all the changes to single table?

Or use dynamic queries that will build the insert based on the name of
table the event happened on?

Or pass arguments?

Best regards,

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-06-11 12:28:45 Re: Gaps in PK sequence numbers [RESOLVED]
Previous Message Francisco Olarte 2024-06-11 07:19:02 Re: libpq v17 PQsocketPoll timeout is not granular enough