On 2016-08-05 10:33:49 -0400, Tom Lane wrote: > Murat Tuncer <mtun...@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.
Well, allowing BEFORE triggers to return NULL or something, preventing the execution of the rest, would be such an implementation, and also independently useful. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
