By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
create table thing (thingid int);
CREATE TABLE
create table thingtwo (thingid int);
CREATE TABLE
create or replace function tf2(thingr thing) returns void as $$
insert into thingtwo values (thingr.thingid);
$$ language sql;
CREATE FUNCTION
create or replace function tf1() returns trigger as $thinginsert$
begin
perform tf2(new);
return null;
end;
$thinginsert$ language plpgsql;
CREATE FUNCTION
create trigger thinginsert
after insert on thing
for each row execute procedure tf1();
CREATE TRIGGER
insert into thing values (5)
INSERT 0 1
select * from thingtwo
| thingid |
|---|
| 5 |
SELECT 1