src/test/modules/test_ddl_deparse/sql/alter_function.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

--
-- ALTER_FUNCTION
--

ALTER FUNCTION plpgsql_function_trigger_1 ()
   SET SCHEMA foo;

ALTER FUNCTION foo.plpgsql_function_trigger_1()
  COST 10;

CREATE ROLE tmprole;

ALTER FUNCTION plpgsql_function_trigger_2()
  OWNER TO tmprole;

DROP OWNED BY tmprole;
DROP ROLE tmprole;