Обсуждение: Add trigger to FDW table

Поиск
Список
Период
Сортировка

Add trigger to FDW table

От
Leonardo M. Ramé
Дата:
Hi, I wonder if I can add a trigger to a Foreign Data Wrapper table. I
can't create the trigger in the foreign database.


Regards,

--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877


Re: Add trigger to FDW table

От
Michael Paquier
Дата:
On Wed, Oct 19, 2016 at 9:29 PM, Leonardo M. Ramé <l.rame@griensu.com> wrote:
> Hi, I wonder if I can add a trigger to a Foreign Data Wrapper table. I can't
> create the trigger in the foreign database.

Creation of triggers on foreign tables is possible since 9.4. They
have the same support as physical tables, without the TRUNCATE trigger
bit.
--
Michael