Home
last modified time | relevance | path

Searched refs:priv_testfunc2 (Results 1 – 25 of 58) sorted by relevance

123

/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/expected/
H A Dprivileges.sql1267 CREATE FUNCTION priv_testfunc2 (int) function
1281 REVOKE ALL ON FUNCTION priv_testfunc1 (int), priv_testfunc2 (int), priv_testagg1 (int) FROM PUBLIC;
1283 GRANT EXECUTE ON FUNCTION priv_testfunc1 (int), priv_testfunc2 (int), priv_testagg1 (int) TO regres…
1321 priv_testfunc2 (5);
2816 DROP FUNCTION priv_testfunc2 (int);
/dports/databases/pgFormatter/pgFormatter-5.1/t/pg-test-files/sql/
H A Dprivileges.sql431 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
435 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
436 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
454 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1123 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-docs/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-plperl/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-contrib/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-client/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-plpython/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-pltcl/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-client/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql11-server/postgresql-11.14/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1236 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-contrib/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-docs/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-server/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql;
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-plpython/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-plperl/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql12-pltcl/postgresql-12.9/src/test/regress/sql/
H A Dprivileges.sql505 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql;
509 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
510 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
528 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1232 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-pltcl/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-plpython/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-server/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-contrib/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql;
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-client/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-docs/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql13-plperl/postgresql-13.5/src/test/regress/sql/
H A Dprivileges.sql551 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
555 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
556 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
574 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1278 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql14-pltcl/postgresql-14.1/src/test/regress/sql/
H A Dprivileges.sql575 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
579 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
580 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
598 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1356 DROP FUNCTION priv_testfunc2(int);
/dports/databases/postgresql14-plperl/postgresql-14.1/src/test/regress/sql/
H A Dprivileges.sql575 CREATE FUNCTION priv_testfunc2(int) RETURNS int AS 'select 3 * $1;' LANGUAGE sql; function
579 REVOKE ALL ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) FROM PUBLIC;
580 GRANT EXECUTE ON FUNCTION priv_testfunc1(int), priv_testfunc2(int), priv_testagg1(int) TO regress_p…
598 SELECT priv_testfunc1(5), priv_testfunc2(5); -- ok
1356 DROP FUNCTION priv_testfunc2(int);

123