codekingpro/portable-devtools

1/* src/test/modules/test_pg_dump/test_pg_dump--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION test_pg_dump" to load this file. \quit5 6CREATE TABLE regress_pg_dump_table (7	col1 serial,8	col2 int check (col2 > 0)9);10 11CREATE SEQUENCE regress_pg_dump_seq;12 13CREATE SEQUENCE regress_seq_dumpable;14SELECT pg_catalog.pg_extension_config_dump('regress_seq_dumpable', '');15GRANT SELECT ON SEQUENCE regress_seq_dumpable TO public;16 17CREATE TABLE regress_table_dumpable (18	col1 int check (col1 > 0)19);20SELECT pg_catalog.pg_extension_config_dump('regress_table_dumpable', '');21GRANT SELECT ON regress_table_dumpable TO public;22 23CREATE SCHEMA regress_pg_dump_schema;24 25GRANT USAGE ON regress_pg_dump_seq TO regress_dump_test_role;26 27GRANT SELECT ON regress_pg_dump_table TO regress_dump_test_role;28GRANT SELECT(col1) ON regress_pg_dump_table TO public;29 30GRANT SELECT(col2) ON regress_pg_dump_table TO regress_dump_test_role;31REVOKE SELECT(col2) ON regress_pg_dump_table FROM regress_dump_test_role;32 33CREATE FUNCTION wgo_then_no_access() RETURNS int LANGUAGE SQL AS 'SELECT 1';34GRANT ALL ON FUNCTION wgo_then_no_access()35	TO pg_signal_backend WITH GRANT OPTION;36 37CREATE SEQUENCE wgo_then_regular;38GRANT ALL ON SEQUENCE wgo_then_regular TO pg_signal_backend WITH GRANT OPTION;39REVOKE GRANT OPTION FOR SELECT ON SEQUENCE wgo_then_regular40	FROM pg_signal_backend;41 42CREATE ACCESS METHOD regress_test_am TYPE INDEX HANDLER bthandler;43 44-- Create a set of objects that are part of the schema created by45-- this extension.46CREATE TABLE regress_pg_dump_schema.test_table (47	col1 int,48	col2 int check (col2 > 0)49);50GRANT SELECT ON regress_pg_dump_schema.test_table TO regress_dump_test_role;51 52CREATE SEQUENCE regress_pg_dump_schema.test_seq;53GRANT USAGE ON regress_pg_dump_schema.test_seq TO regress_dump_test_role;54 55CREATE TYPE regress_pg_dump_schema.test_type AS (col1 int);56GRANT USAGE ON TYPE regress_pg_dump_schema.test_type TO regress_dump_test_role;57 58CREATE FUNCTION regress_pg_dump_schema.test_func () RETURNS int59AS 'SELECT 1;' LANGUAGE SQL;60GRANT EXECUTE ON FUNCTION regress_pg_dump_schema.test_func() TO regress_dump_test_role;61 62CREATE AGGREGATE regress_pg_dump_schema.test_agg(int2)63(SFUNC = int2_sum, STYPE = int8);64GRANT EXECUTE ON FUNCTION regress_pg_dump_schema.test_agg(int2) TO regress_dump_test_role;65