Re: TRIGGER on a FOREIGN Table? - Mailing list pgsql-admin

From Sbob
Subject Re: TRIGGER on a FOREIGN Table?
Date
Msg-id a78e819f-c10a-4e03-9313-0bb2689892b9@quadratum-braccas.com
Whole thread Raw
In response to Re: TRIGGER on a FOREIGN Table?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Got it, Thanks!


On 11/7/23 00:30, Laurenz Albe wrote:
> On Mon, 2023-11-06 at 21:15 -0700, Sbob wrote:
>> does anyone know: can I create a trigger on a foreign table? I suspect I
>> have to create the trigger on the remote / source table yes?
> You can create a trigger on a foreign table.  But don't get confused:
>
> - the trigger will run locally, not on the remote database
> - the trigger will not run if the table on the remote database is modified
>
> Yours,
> Laurenz Albe



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
Next
From: Erik Serrano
Date:
Subject: Re: Not able to connect specific database