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