1CREATE ROLE regress_dump_test_role; 2CREATE EXTENSION test_pg_dump; 3ALTER EXTENSION test_pg_dump ADD DATABASE postgres; -- error 4ERROR: syntax error at or near "DATABASE" 5LINE 1: ALTER EXTENSION test_pg_dump ADD DATABASE postgres; 6 ^ 7CREATE TABLE test_pg_dump_t1 (c1 int); 8CREATE VIEW test_pg_dump_v1 AS SELECT * FROM test_pg_dump_t1; 9CREATE MATERIALIZED VIEW test_pg_dump_mv1 AS SELECT * FROM test_pg_dump_t1; 10CREATE SCHEMA test_pg_dump_s1; 11CREATE TYPE test_pg_dump_e1 AS ENUM ('abc', 'def'); 12CREATE AGGREGATE newavg ( 13 sfunc = int4_avg_accum, basetype = int4, stype = _int8, 14 finalfunc = int8_avg, 15 initcond1 = '{0,0}' 16); 17CREATE FUNCTION test_pg_dump(int) RETURNS int AS $$ 18BEGIN 19RETURN abs($1); 20END 21$$ LANGUAGE plpgsql IMMUTABLE; 22CREATE OPERATOR ==== ( 23 LEFTARG = int, 24 RIGHTARG = int, 25 PROCEDURE = int4eq, 26 COMMUTATOR = ==== 27); 28CREATE ACCESS METHOD gist2 TYPE INDEX HANDLER gisthandler; 29CREATE TYPE casttesttype; 30CREATE FUNCTION casttesttype_in(cstring) 31 RETURNS casttesttype 32 AS 'textin' 33 LANGUAGE internal STRICT IMMUTABLE; 34NOTICE: return type casttesttype is only a shell 35CREATE FUNCTION casttesttype_out(casttesttype) 36 RETURNS cstring 37 AS 'textout' 38 LANGUAGE internal STRICT IMMUTABLE; 39NOTICE: argument type casttesttype is only a shell 40CREATE TYPE casttesttype ( 41 internallength = variable, 42 input = casttesttype_in, 43 output = casttesttype_out, 44 alignment = int4 45); 46CREATE CAST (text AS casttesttype) WITHOUT FUNCTION; 47CREATE FOREIGN DATA WRAPPER dummy; 48CREATE SERVER s0 FOREIGN DATA WRAPPER dummy; 49CREATE FOREIGN TABLE ft1 ( 50 c1 integer OPTIONS ("param 1" 'val1') NOT NULL, 51 c2 text OPTIONS (param2 'val2', param3 'val3') CHECK (c2 <> ''), 52 c3 date, 53 CHECK (c3 BETWEEN '1994-01-01'::date AND '1994-01-31'::date) 54) SERVER s0 OPTIONS (delimiter ',', quote '"', "be quoted" 'value'); 55REVOKE EXECUTE ON FUNCTION test_pg_dump(int) FROM PUBLIC; 56GRANT EXECUTE ON FUNCTION test_pg_dump(int) TO regress_dump_test_role; 57GRANT SELECT (c1) ON test_pg_dump_t1 TO regress_dump_test_role; 58GRANT SELECT ON test_pg_dump_v1 TO regress_dump_test_role; 59GRANT USAGE ON FOREIGN DATA WRAPPER dummy TO regress_dump_test_role; 60GRANT USAGE ON FOREIGN SERVER s0 TO regress_dump_test_role; 61GRANT SELECT (c1) ON ft1 TO regress_dump_test_role; 62GRANT SELECT ON ft1 TO regress_dump_test_role; 63GRANT UPDATE ON test_pg_dump_mv1 TO regress_dump_test_role; 64GRANT USAGE ON SCHEMA test_pg_dump_s1 TO regress_dump_test_role; 65GRANT USAGE ON TYPE test_pg_dump_e1 TO regress_dump_test_role; 66ALTER EXTENSION test_pg_dump ADD ACCESS METHOD gist2; 67ALTER EXTENSION test_pg_dump ADD AGGREGATE newavg(int4); 68ALTER EXTENSION test_pg_dump ADD CAST (text AS casttesttype); 69ALTER EXTENSION test_pg_dump ADD FOREIGN DATA WRAPPER dummy; 70ALTER EXTENSION test_pg_dump ADD FOREIGN TABLE ft1; 71ALTER EXTENSION test_pg_dump ADD MATERIALIZED VIEW test_pg_dump_mv1; 72ALTER EXTENSION test_pg_dump ADD OPERATOR ==== (int, int); 73ALTER EXTENSION test_pg_dump ADD SCHEMA test_pg_dump_s1; 74ALTER EXTENSION test_pg_dump ADD SERVER s0; 75ALTER EXTENSION test_pg_dump ADD FUNCTION test_pg_dump(int); 76ALTER EXTENSION test_pg_dump ADD TABLE test_pg_dump_t1; 77ALTER EXTENSION test_pg_dump ADD TYPE test_pg_dump_e1; 78ALTER EXTENSION test_pg_dump ADD VIEW test_pg_dump_v1; 79REVOKE SELECT (c1) ON test_pg_dump_t1 FROM regress_dump_test_role; 80REVOKE SELECT ON test_pg_dump_v1 FROM regress_dump_test_role; 81REVOKE USAGE ON FOREIGN DATA WRAPPER dummy FROM regress_dump_test_role; 82ALTER EXTENSION test_pg_dump DROP ACCESS METHOD gist2; 83ALTER EXTENSION test_pg_dump DROP AGGREGATE newavg(int4); 84ALTER EXTENSION test_pg_dump DROP CAST (text AS casttesttype); 85ALTER EXTENSION test_pg_dump DROP FOREIGN DATA WRAPPER dummy; 86ALTER EXTENSION test_pg_dump DROP FOREIGN TABLE ft1; 87ALTER EXTENSION test_pg_dump DROP FUNCTION test_pg_dump(int); 88ALTER EXTENSION test_pg_dump DROP MATERIALIZED VIEW test_pg_dump_mv1; 89ALTER EXTENSION test_pg_dump DROP OPERATOR ==== (int, int); 90ALTER EXTENSION test_pg_dump DROP SCHEMA test_pg_dump_s1; 91ALTER EXTENSION test_pg_dump DROP SERVER s0; 92ALTER EXTENSION test_pg_dump DROP TABLE test_pg_dump_t1; 93ALTER EXTENSION test_pg_dump DROP TYPE test_pg_dump_e1; 94ALTER EXTENSION test_pg_dump DROP VIEW test_pg_dump_v1; 95