github.com/tuhaihe/gpbackup@v1.0.3/end_to_end/resources/gpdb6_objects.sql (about)

     1  SET statement_timeout = 0;
     2  SET client_encoding = 'UTF8';
     3  SET standard_conforming_strings = on;
     4  SET check_function_bodies = false;
     5  SET client_min_messages = warning;
     6  
     7  SET search_path = public, pg_catalog;
     8  
     9  SET default_with_oids = false;
    10  
    11  
    12  CREATE TYPE employee_type AS (
    13  	name text,
    14  	salary numeric
    15  );
    16  
    17  
    18  CREATE FUNCTION add(integer, integer) RETURNS integer
    19      LANGUAGE sql WINDOW CONTAINS SQL
    20      AS $_$SELECT $1 + $2$_$;
    21  
    22  
    23  CREATE FUNCTION mleast(VARIADIC arr numeric[]) RETURNS numeric
    24      LANGUAGE sql CONTAINS SQL
    25      AS $_$
    26      SELECT min($1[i]) FROM generate_subscripts($1, 1) g(i);
    27  $_$;
    28  
    29  
    30  CREATE FOREIGN DATA WRAPPER fdw;
    31  
    32  CREATE SERVER sc FOREIGN DATA WRAPPER fdw;
    33  
    34  CREATE USER MAPPING FOR testrole
    35          SERVER sc
    36          OPTIONS (user 'foreign_user', password 'password');
    37  
    38  
    39  CREATE FOREIGN TABLE ft1 (
    40      c1 integer OPTIONS (param1 'val1') NOT NULL,
    41      c2 text OPTIONS (param2 'val2', param3 'val3')
    42  ) SERVER sc OPTIONS (delimiter ',', quote '"');
    43  
    44  CREATE OR REPLACE FUNCTION do_nothing()
    45    RETURNS event_trigger
    46   LANGUAGE plpgsql
    47    AS $$
    48  BEGIN END;
    49  $$;
    50  
    51  CREATE EVENT TRIGGER nothing_ddl ON ddl_command_start
    52     WHEN TAG IN ('ALTER SERVER')
    53     EXECUTE PROCEDURE do_nothing();
    54  
    55  CREATE COLLATION public.some_coll (lc_collate = 'POSIX', lc_ctype = 'POSIX');
    56  
    57  CREATE TYPE public.textrange AS RANGE (
    58  	SUBTYPE_OPCLASS = public.range_class,
    59  	SUBTYPE = pg_catalog.text,
    60  	COLLATION = public.some_coll
    61  );
    62  
    63  CREATE TYPE public.colors AS ENUM (
    64      'red',
    65      'green',
    66      'blue'
    67  );
    68  CREATE TABLE public.legacy_enum (
    69      color public.colors
    70  ) DISTRIBUTED BY (color cdbhash_enum_ops);
    71  
    72  CREATE TABLE aa (
    73      a integer NOT NULL,
    74      b integer NOT NULL,
    75      c integer
    76  ) DISTRIBUTED BY (a, b);
    77  ALTER TABLE ONLY aa REPLICA IDENTITY FULL;
    78  
    79  CREATE TABLE t (a int, b text);
    80  SECURITY LABEL ON TABLE t IS 'classified';
    81  
    82  CREATE OR REPLACE FUNCTION test_function()
    83    RETURNS TRIGGER
    84   LANGUAGE plpgsql
    85    AS $$
    86  BEGIN END;
    87  $$;
    88  
    89  CREATE CONSTRAINT TRIGGER ensure_user_role_exists
    90  AFTER INSERT OR UPDATE ON aa
    91  FOR EACH ROW
    92  EXECUTE PROCEDURE test_function();