CREATE OR REPLACE FUNCTION public.drop_contrig(name, name)
  RETURNS SETOF text AS
'
--удаляет констрайнт триггеры
DECLARE
	vctgname name;
	vtgname	name;
	vrelname name;
	vrec RECORD;
	--vrec1 RECORD;
BEGIN
	vctgname = $1;
	vrelname = $2;
	FOR vrec IN SELECT t.tgname  
		FROM pg_class c, pg_trigger t 
		WHERE c.oid = t.tgrelid
		AND  tgconstrname = vctgname
		AND vrelname = vrelname
	LOOP
		vtgname := vrec.tgname;

			EXECUTE \'DROP TRIGGER \'|| quote_ident(vtgname)
		|| \' ON \' || quote_ident(vrelname) ;

		--SELECT INTO vrec1 quote_ident(vrelname), quote_ident(vtgname);
		--RETURN NEXT quote_ident(vrelname), quote_ident(vtgname);
		RETURN NEXT quote_ident(vtgname);
	END LOOP;	
	RETURN; -- \'NULL\';
END;'
  LANGUAGE 'plpgsql' VOLATILE;