Postgres Pro
Downloads
Home   >   mailing lists

Re: Add trigger to FDW table - Mailing list pgsql-general

From Michael Paquier
Subject Re: Add trigger to FDW table
Date
Msg-id CAB7nPqTv9zuuEvzBcbs_WuRNDXOxTq4Z0tFL+NetGpVMmyWdpw@mail.gmail.com
Whole thread Raw
In response to Add trigger to FDW table  (Leonardo M. Ramé <l.rame@griensu.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Leonardo M. Ramé
Date:
Subject: Add trigger to FDW table
Next
From: "Alex Ignatov \(postgrespro\)"
Date:
Subject: Re: journaled FS and and WAL