Re: Trigger Function question

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: DAVID ROTH <adaptron(at)comcast(dot)net>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Trigger Function question
Date: 2023-07-10 18:38:37
Message-ID: 8EE88849-3AF9-4B39-B547-B502173AE5F6@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jul 10, 2023, at 11:37, DAVID ROTH <adaptron(at)comcast(dot)net> wrote:
>
> Thanks for the example. I have a test trigger now that does that but my application needs all of the columns.

I'm not quite sure I understanding. Logging NEW.* and OLD.* *does* get all the columns, without having to specific query to find out which columns the table that cause the trigger to fire has.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DAVID ROTH 2023-07-10 18:42:00 Re: Trigger Function question
Previous Message DAVID ROTH 2023-07-10 18:37:06 Re: Trigger Function question