CREATE TABLE public.leaf
(
  id int4 NOT NULL,
...
...
  value float8,
  CONSTRAINT leaf_pkey PRIMARY KEY (id),
  CONSTRAINT company_leaf FOREIGN KEY (company) REFERENCES public.company (id) ON UPDATE CASCADE ON DELETE CASCADE,
  CONSTRAINT tl_id FOREIGN KEY (id) REFERENCES public.tree (id) ON UPDATE CASCADE ON DELETE CASCADE

CREATE TRIGGER leaf_delete_values
  AFTER DELETE
  ON public.leaf
  FOR EACH ROW
  EXECUTE PROCEDURE public.tr_delete_leaf_values();

CREATE TABLE test_before_insert AS 
SELECT DISTINCT  t_values.* FROM t_values
INNER JOIN t_parents ON tid = pid 
WHERE id =  19831  OR pid =  19831 ;


INSERT INTO tree 
(id, pid, pos, uname_create, uname_modify, date_create, date_modify, status )
 VALUES 
(- 18 ,  19831 , - 18 ,'test','test',  1050131 ,  1050131 , - 1  );

INSERT INTO leaf 
(id,  company, kind, date, name, description, search_name, currency, value, payment_kind, planfact )

VALUES 
(- 18 ,   2 ,  1 ,  1050131 , 'test_insert', 'test_insert', 'test_insert',  0 ,  1 , -  1  ,  1  );

CREATE TABLE test_past_insert AS 
SELECT  DISTINCT t_values.* FROM t_values
INNER JOIN t_parents ON tid = pid 
WHERE id =  19831  OR pid =  19831 ;

/*
DELETE FROM leaf WHERE id = -18; 
*/
DELETE FROM tree WHERE id = - 18 ; --каскад


CREATE TABLE test_past_delete AS 
SELECT  DISTINCT  t_values.* FROM t_values
INNER JOIN t_parents ON tid = pid 
WHERE id =  19831  OR pid =  19831 ;

SELECT DISTINCT b.*, b.value - p.value AS delt FROM

test_before_insert b
--test_past_insert b

RIGHT JOIN 

--test_past_insert p
test_past_delete p

USING (tid ,  payment_kind ,  planfact ,  currency ,  ayear ,  amonth )
WHERE
  b.value - p.value <>  0  OR b.value IS NULL
;

CREATE TABLE public.main
(
  m_id serial NOT NULL,
  m_name varchar( 128 ),
  CONSTRAINT m_id_pkey PRIMARY KEY (m_id)
) WITHOUT OIDS;


CREATE TABLE public.main_add
(
  a_id int4 NOT NULL,
  a_name varchar( 128 ),
  CONSTRAINT a_id_pkey PRIMARY KEY (a_id),
  CONSTRAINT ma_id_fkey FOREIGN KEY (a_id) REFERENCES public.main (m_id) ON UPDATE CASCADE ON DELETE CASCADE
) WITHOUT OIDS;

CREATE OR REPLACE FUNCTION public.tr_test()
  RETURNS trigger AS
'DECLARE
 olid int4;
BEGIN
SELECT INTO olid OLD.a_id;

RAISE NOTICE \'Oid here is %\',  olid ;
RETURN OLD;
END;'
  LANGUAGE 'plpgsql' IMMUTABLE;

CREATE TRIGGER tr_test
  AFTER DELETE
  ON public.main_add
  FOR EACH ROW
  EXECUTE PROCEDURE public.tr_test();

DELETE FROM main_add 
WHERE 
  a_id =  11 ; 

NOTICE:  Oid here is  11 

DELETE FROM main
WHERE 
  m_id =  10 ; 

NOTICE:  Oid here is  10