Well, I think is not a transaction problem, because if you do the same thing
on a DO it will work.
DO $$
declare vMaster_ID integer;
begin
insert into Master(Customer_ID, Field2) values(1, 'BlaBla') returning
Master_ID into vMaster_ID;
insert into Detail(Master_ID, Product_ID, ProductValue) values(vMaster_ID,
5, 50);
end $$
As you can see, works exactly the same way and Detail trigger works as
expected, why ?
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html