/
balmaster
/
postgres
Обзор
Документация
Войти
/
balmaster
/
postgres
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
src/test/modules/test_ddl_deparse/sql/test_ddl_deparse.sql
42 строки
1 KB
Michael Paquier
Expand tests of test_ddl_deparse/ for ALTER TABLE
31 июл 2022, 05:48
31 июл 2022, 05:48
07ff701
Код
Авторство
О чём код?
CREATE EXTENSION test_ddl_deparse; CREATE OR REPLACE FUNCTION test_ddl_deparse() RETURNS event_trigger LANGUAGE plpgsql AS $$ DECLARE r record; r2 record; cmdtype text; objtype text; tag text; BEGIN FOR r IN SELECT * FROM pg_event_trigger_ddl_commands() LOOP -- verify that tags match tag = public.get_command_tag(r.command); IF tag <> r.command_tag THEN RAISE NOTICE 'tag % doesn''t match %', tag, r.command_tag; END IF; -- log the operation cmdtype = public.get_command_type(r.command); IF cmdtype <> 'grant' THEN RAISE NOTICE 'DDL test: type %, tag %', cmdtype, tag; ELSE RAISE NOTICE 'DDL test: type %, object type %', cmdtype, r.object_type; END IF; -- if alter table, log more IF cmdtype = 'alter table' THEN FOR r2 IN SELECT * FROM public.get_altertable_subcmdinfo(r.command) LOOP RAISE NOTICE ' subcommand: type % desc %', r2.cmdtype, r2.objdesc; END LOOP; END IF; END LOOP; END; $$; CREATE EVENT TRIGGER test_ddl_deparse ON ddl_command_end EXECUTE PROCEDURE test_ddl_deparse();