bizrhythm.public

Parameters

Name	Type	Mode
		IN

Definition

DECLARE
    obj RECORD;
    v_is_local BOOLEAN := current_database() = 'postrhythm';
BEGIN
    FOR obj IN SELECT * FROM pg_event_trigger_dropped_objects() LOOP
        IF obj.object_type = 'extension' THEN
            BEGIN
                IF v_is_local THEN
                    INSERT INTO catalog.extension_history
                        (host, database, extname, event, old_version, source)
                    VALUES ('dante', current_database(), obj.object_name, 'removed', NULL, 'event-trigger');
                ELSE
                    INSERT INTO public.postrhythm_extension_history
                        (host, database, extname, event, old_version, source)
                    VALUES ('dante', current_database(), obj.object_name, 'removed', NULL, 'event-trigger');
                END IF;
            EXCEPTION WHEN OTHERS THEN
                RAISE WARNING 'catalog_extension_drop_event: could not record % on %: %',
                    obj.object_name, current_database(), SQLERRM;
            END;
        END IF;
    END LOOP;
END;

catalog_extension_drop_event()

Parameters

Definition