Postgres Pro
Downloads
Home   >   mailing lists

Re: truncate trigger for foreign data wrappers - Mailing list pgsql-hackers

From Tom Lane
Subject Re: truncate trigger for foreign data wrappers
Date
Msg-id 4436.1470407629@sss.pgh.pa.us
Whole thread Raw
In response to truncate trigger for foreign data wrappers  (Murat Tuncer <mtuncer@citusdata.com>)
Responses Re: truncate trigger for foreign data wrappers  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
Tree view 
Murat Tuncer <mtuncer@citusdata.com> writes:
> I recently hit a road blocker when I tried to create a truncate trigger on
> a foreign table. trigger.c::CreateTrigger() function has explicit check to
> block truncate trigger on foreign tables.

That's good, because we don't implement TRUNCATE on foreign tables: there
is nothing in the FDW API that would support it.  Not much point in
declaring a trigger for an event that can never happen.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bogus ANALYZE results for an otherwise-unique column with many nulls
Next
From: Andres Freund
Date:
Subject: Re: truncate trigger for foreign data wrappers