Re: TRIGGER on a FOREIGN Table?

Поиск
Список
Период
Сортировка
От Sbob
Тема Re: TRIGGER on a FOREIGN Table?
Дата
Msg-id a78e819f-c10a-4e03-9313-0bb2689892b9@quadratum-braccas.com
обсуждение исходный текст
Ответ на Re: TRIGGER on a FOREIGN Table?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
Следующее
От: Erik Serrano
Дата:
Сообщение: Re: Not able to connect specific database