Re: TRIGGER on a FOREIGN Table?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Sbob <sbob(at)quadratum-braccas(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: TRIGGER on a FOREIGN Table?
Date: 2023-11-07 07:30:15
Message-ID: 5031db5a11ea0e29b16b4a08e7dd0a3f67f55444.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-11-07 13:09:17 Re: Frequent failover
Previous Message Rajesh Kumar 2023-11-07 05:44:25 Re: Frequent failover