Hello,
> trg=# ALTER TABLE t ALTER COLUMN f1 DROP IDENTITY, ALTER COLUMN f1 SET
> DATA TYPE bigint;
> ERROR: XX000: cache lookup failed for relation 13476892
> CONTEXT: PL/pgSQL function ddl_end() line 5 at FOR over SELECT rows
> LOCATION: getRelationTypeDescription, objectaddress.c:4178
Is this expected behaviour or something that should be fixed?
The documentation for pg_event_trigger_ddl_commands doesnt mention
that it could fail for certain statements.
Is catching the exception the only way to deal with this in caller or
is there another way to handle this gracefully?
--
Regards, Sven Klemm