/* */ /* This file is auto generated by pgrx. The ordering of items is not stable, it is driven by a dependency graph. */ /* */ /* */ -- demo/src/lib.rs:1 CREATE SCHEMA IF NOT EXISTS demo; /* demo::demo */ /* */ /* */ -- demo/src/registry.rs:10 -- requires: -- demo CREATE TABLE demo.tables ( relid regclass PRIMARY KEY, mode text NOT NULL DEFAULT 'local' CHECK (mode IN ('local', 'remote')), -- free-form note note text DEFAULT 'none', retries int NOT NULL DEFAULT 3, dropped_col text, created_at timestamptz NOT NULL DEFAULT now() ); REVOKE ALL ON demo.tables FROM PUBLIC; SELECT pg_catalog.pg_extension_config_dump('demo.tables', ''); /* */ /* */ -- demo/src/queue.rs:5 -- requires: -- demo CREATE TABLE demo.legacy_queue (id bigserial PRIMARY KEY, payload jsonb); /* */ /* */ -- demo/src/queue.rs:30 -- requires: -- demo CREATE TABLE demo.outbox ( id bigserial PRIMARY KEY, op text NOT NULL CHECK (op IN ('upsert', 'delete')), payload jsonb ); CREATE INDEX demo_outbox_op_idx ON demo.outbox (op); /* */ /* */ -- demo/src/lib.rs:20 -- demo::demo::plain_c CREATE FUNCTION demo."plain_c"( "tbl" regclass /* PgRelation */ ) RETURNS void STRICT LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'plain_c_wrapper'; /* */ /* */ -- demo/src/lib.rs:40 -- requires: -- demo CREATE FUNCTION demo.body_change(x integer) RETURNS integer LANGUAGE plpgsql AS $$ BEGIN RETURN x + 1; END; $$; REVOKE EXECUTE ON FUNCTION demo.body_change(integer) FROM PUBLIC; /* */ /* */ -- demo/src/lib.rs:60 -- requires: -- demo CREATE FUNCTION demo.comment_only(x int) RETURNS int LANGUAGE plpgsql AS $$ BEGIN -- old comment RETURN x; -- semicolon; in a comment END; $$; /* */ /* */ -- demo/src/lib.rs:80 -- demo::demo::removed_fn CREATE FUNCTION demo."removed_fn"( "s" TEXT /* &str */ ) RETURNS TEXT /* String */ LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'removed_fn_wrapper'; /* */ /* */ -- demo/src/lib.rs:90 -- demo::demo::table_fn CREATE FUNCTION demo."table_fn"() RETURNS TABLE ( "a" INT /* i32 */ ) LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'table_fn_wrapper'; /* */ /* */ -- demo/src/lib.rs:95 -- requires: -- table_fn REVOKE EXECUTE ON FUNCTION demo.table_fn() FROM PUBLIC; /* */ /* */ -- demo/src/lib.rs:100 -- demo::demo::renamed_param CREATE FUNCTION demo."renamed_param"( "old_name" TEXT /* &str */ ) RETURNS void LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'renamed_param_wrapper'; /* */ /* */ -- demo/src/lib.rs:110 -- demo::demo::sig_change CREATE FUNCTION demo."sig_change"( "a" INT /* i32 */ ) RETURNS INT /* i32 */ LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'sig_change_wrapper'; /* */ /* */ -- demo/src/lib.rs:120 -- demo::demo::search CREATE FUNCTION demo."search"( "q" TEXT, /* &str */ "k" INT DEFAULT 10 /* Option < i32 > */ ) RETURNS TABLE ( "id" TEXT, /* String */ "score" real /* f32 */ ) LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'search_wrapper'; /* */ /* */ -- demo/src/lib.rs:130 -- requires: -- search ALTER FUNCTION demo.search(text, integer) ROWS 100; /* */ /* */ -- demo/src/hooks.rs:1 -- requires: -- demo CREATE FUNCTION demo._on_drop() RETURNS event_trigger LANGUAGE plpgsql AS $$ BEGIN PERFORM 1; END; $$; CREATE EVENT TRIGGER demo_on_drop ON sql_drop EXECUTE FUNCTION demo._on_drop(); CREATE EVENT TRIGGER demo_on_ddl ON ddl_command_end WHEN TAG IN ('ALTER TABLE') EXECUTE FUNCTION demo._on_drop(); CREATE EVENT TRIGGER demo_removed ON ddl_command_start EXECUTE FUNCTION demo._on_drop(); /* */ /* */ -- demo/src/views.rs:1 -- requires: -- demo CREATE VIEW demo.v_status AS SELECT relid, mode FROM demo.tables; CREATE VIEW demo.v_gone AS SELECT 1 AS one; /* */ /* */ -- demo/src/am.rs:1 -- requires: -- demo SELECT demo._install_opclasses(); COMMENT ON TABLE demo.tables IS 'registry'; /* */ /* */ -- demo/src/am.rs:100 CREATE FUNCTION demo."_install_opclasses"() RETURNS void LANGUAGE c /* Rust */ AS 'MODULE_PATHNAME', 'install_opclasses_wrapper'; /* */ /* */ -- demo/src/am.rs:200 -- requires: -- demo CREATE ACCESS METHOD demo_am TYPE INDEX HANDLER demo._am_handler; CREATE OPERATOR <#> (LEFTARG = real[], RIGHTARG = real[], FUNCTION = demo.dist); /* */