Postgres Pro
Downloads
Home   >   mailing lists

Re: PLPGSQL - extra column existence in trigger - Mailing list pgsql-general

From Durumdara
Subject Re: PLPGSQL - extra column existence in trigger
Date
Msg-id CAEcMXhkwVw46F=nmQ8fD7n32DtPowZAnZAFqzWZFqwq+F6R=6A@mail.gmail.com
Whole thread Raw
In response to Re: PLPGSQL - extra column existence in trigger  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
Hello!

Peter J. Holzer <hjp-pgsql@hjp.at> ezt írta (időpont: 2022. máj. 11., Sze, 0:44):
On 2022-05-07 15:02:09 +0200, Durumdara wrote:

> So in the new trigger we can't load them all with:

How do you get a new trigger on one table but not the new columns on the
other table? Wouldn't you update both at the same time?

The needed columns are in a temporary table. Each Win32 application creates his own temp table with User Informations, like ID, Name, Computer Info.
These are for logging purposes.
The trigger is in another table, and I want to log the actual user information with the row changing to see who caused it.

Best regards,
dd
 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: list tablespaces named in custom format dump
Next
From: Rob Sargent
Date:
Subject: Re: list tablespaces named in custom format dump