Add trigger to FDW table

Started by Leonardo M. Raméover 9 years ago2 messagesgeneral
Jump to latest
#1Leonardo M. Ramé
l.rame@griensu.com

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Michael Paquier
michael@paquier.xyz
In reply to: Leonardo M. Ramé (#1)
Re: Add trigger to FDW table

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general