NOTICE: Table 'rewriteme' is being rewritten (reason = 6)

-- shouldn't trigger a table_rewrite event

alter table rewriteme alter column foo type numeric(12,4);

-- typed tables are rewritten when their type changes

-- typed tables are rewritten when their type changes. Don't emit table

-- name, because firing order is not stable.

CREATE OR REPLACE FUNCTION test_evtrig_no_rewrite() RETURNS event_trigger

LANGUAGE plpgsql AS $$

BEGIN

RAISE NOTICE 'Table is being rewritten (reason = %)',

pg_event_trigger_table_rewrite_reason();

END;

$$;

create type rewritetype as (a int);

create table rewritemetoo1 of rewritetype;

create table rewritemetoo2 of rewritetype;

alter type rewritetype alter attribute a type text cascade;

NOTICE: Table'rewritemetoo1'is being rewritten (reason = 4)

NOTICE: Table'rewritemetoo2'is being rewritten (reason = 4)

NOTICE: Table is being rewritten (reason = 4)

NOTICE: Table is being rewritten (reason = 4)

-- but this doesn't work

create table rewritemetoo3 (a rewritetype);

alter type rewritetype alter attribute a type varchar cascade;

altertable rewriteme alter column foo typenumeric(12,4);

CREATE OR REPLACEFUNCTIONtest_evtrig_no_rewrite() RETURNS event_trigger

LANGUAGE plpgsqlAS $$

RAISE NOTICE'Table is being rewritten (reason = %)',

pg_event_trigger_table_rewrite_reason();

END;

$$;

createtyperewritetypeas (aint);

createtablerewritemetoo1 of rewritetype;

createtablerewritemetoo2 of rewritetype;