Re: Add trigger to FDW table

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Leonardo M(dot) Ramé <l(dot)rame(at)griensu(dot)com>
Cc: PostgreSql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Add trigger to FDW table
Date: 2016-10-19 12:44:46
Message-ID: CAB7nPqTv9zuuEvzBcbs_WuRNDXOxTq4Z0tFL+NetGpVMmyWdpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 19, 2016 at 9:29 PM, Leonardo M. Ramé <l(dot)rame(at)griensu(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Ignatov (postgrespro) 2016-10-19 12:59:28 Re: journaled FS and and WAL
Previous Message Leonardo M. Ramé 2016-10-19 12:29:39 Add trigger to FDW table