--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;

--
-- TOC entry 3 (OID 17147)
-- Name: tst_s; Type: SCHEMA; Schema: -; Owner: 
--

CREATE SCHEMA tst_s AUTHORIZATION postgres;

SET SESSION AUTHORIZATION 'postgres';

SET search_path = public, pg_catalog;

--
-- TOC entry 8 (OID 17144)
-- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;

SET SESSION AUTHORIZATION DEFAULT;

--
-- TOC entry 7 (OID 17145)
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: 
--

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 5 (OID 2200)
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;

SET SESSION AUTHORIZATION 'postgres';

--
-- TOC entry 9 (OID 17146)
-- Name: tst_f(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION tst_f() RETURNS integer
    AS 'begin; return 0; end;'
    LANGUAGE plpgsql;

SET search_path = tst_s, pg_catalog;

--
-- TOC entry 6 (OID 17148)
-- Name: t; Type: TABLE; Schema: tst_s; Owner: postgres
--

CREATE TABLE t (
    a integer,
    CONSTRAINT "$1" CHECK ((public.tst_f() = 0))
);

--
-- Data for TOC entry 10 (OID 17148)
-- Name: t; Type: TABLE DATA; Schema: tst_s; Owner: postgres
--

COPY t (a) FROM stdin;
\.

--
-- TOC entry 4 (OID 2200)
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';