}

context->rtables=list_delete_first(context->rtables);

break;

caseRTE_NAMEDTUPLESTORE:

ereport(ERROR,

(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),

errmsg("transition table \"%s\" cannot be referenced in a persistent object",

rte->eref->aliasname)));

break;

default:

break;

}

}

ERROR: transition tables cannot be specified for triggers with column lists

drop table my_table;

--

-- Verify that transition tables can't be used in, eg, a view.

--

create table my_table (a int);

create function make_bogus_matview() returns trigger as

$$ begin

create materialized view transition_test_mv as select * from new_table;

return new;

end $$

language plpgsql;

create trigger make_bogus_matview

after insert on my_table

referencing new table as new_table

for each statement execute function make_bogus_matview();

insert into my_table values (42); -- error

ERROR: transition table "new_table" cannot be referenced in a persistent object

CONTEXT: SQL statement "create materialized view transition_test_mv as select * from new_table"

PL/pgSQL function make_bogus_matview() line 2 at SQL statement

drop table my_table;

drop function make_bogus_matview();

--

-- Test firing of triggers with transition tables by foreign key cascades

--

create table refd_table (a int primary key, b text);

droptable my_table;

createtablemy_table (aint);

createfunctionmake_bogus_matview() returns triggeras

$$begin

create materialized view transition_test_mvasselect*from new_table;

return new;

end $$

language plpgsql;

after inserton my_table

referencing new tableas new_table

for each statement execute function make_bogus_matview();

insert into my_tablevalues (42);-- error

droptable my_table;

dropfunction make_bogus_matview();