Triggers on foreign tables - Mailing list pgsql-hackers

From Ronan Dunklau
Subject Triggers on foreign tables
Date
Msg-id 1553612.aNJakFASte@ronan_laptop
Whole thread Raw
Responses Re: Triggers on foreign tables
Re: Triggers on foreign tables
List pgsql-hackers
Hello.

I wanted to know what it would take to implement triggers on foreign tables.
It seems that statement-level triggers can work provided they are allowed in
the code.

Please find attached a simple POC patch that implement just that.

For row-level triggers, it seems more complicated. From what I understand,
OLD/NEW tuples are fetched from the heap using their ctid (except for BEFORE
INSERT triggers). How could this be adapted for foreign tables ?


--
Ronan Dunklau
Attachment

pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Hstore: Query speedups with Gin index
Next
From: "MauMau"
Date:
Subject: Re: [bug fix] strerror() returns ??? in a UTF-8/C database withLC_MESSAGES=non-ASCII