Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION schema.abort_adding_column()
- RETURNS event_trigger
- LANGUAGE plpgsql
- AS $$
- DECLARE
- obj record;
- BEGIN
- For obj IN SELECT * FROM information_schema.tables AND table_schema IN ('schema1') AND table_catalog = 'database1';
- LOOP
- RAISE EXCEPTION 'command % is not allowed on %s, see blah blah for more details.', tg_tag;
- END LOOP;
- END;
- $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement