bug(postgres-cdc): after recreate enum, debezium fail to update.

[KeXiangWang]

Describe the bug

In Pg, when delete and recreate a enum. The oid of enum is changed. However, debezium fails to capture this change. The root cause seems to be this https://issues.redhat.com/browse/DBZ-2045.

Error message/log

No response

To Reproduce

SQLs to create enum

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');

SELECT oid
FROM pg_type
WHERE typname = 'mood';
--- for example, if we get 16390 from the above query.

Create a table based on the enum:

CREATE TABLE IF NOT EXISTS postgres_enum(
     c_boolean boolean,
     c_enum mood,
     PRIMARY KEY (c_boolean)
);
INSERT INTO postgres_single_types VALUES( False, 'happy' );

In rw, create a source and a table capturing the postgres_enum table.
Then drop everything, including the tables in RW and PG, and the enum.
Redo the steps again. In compute node's log, you will find sth like:

2024-05-21T14:17:31.586834-04:00  WARN risingwave_connector_node: Unknown OID 16390 requested thread="debezium-postgresconnector-RW_CDC_5-change-event-source-coordinator" class="io.debezium.connector.postgresql.TypeRegistry"
2024-05-21T14:17:31.58767-04:00  WARN risingwave_connector_node: Unknown OID -1 requested thread="debezium-postgresconnector-RW_CDC_5-change-event-source-coordinator" class="io.debezium.connector.postgresql.TypeRegistry"
2024-05-21T14:17:31.587756-04:00  WARN risingwave_connector_node: Unexpected JDBC type '-2147483648' for column 'c_enum' that will be ignored thread="debezium-postgresconnector-RW_CDC_5-change-event-source-coordinator" class="io.debezium.relational.TableSchemaBuilder"
2024-05-21T14:17:31.58823-04:00  WARN risingwave_connector_node: Unknown OID -1 requested thread="debezium-postgresconnector-RW_CDC_5-change-event-source-coordinator" class="io.debezium.connector.postgresql.TypeRegistry"
2024-05-21T14:17:31.588272-04:00  WARN risingwave_connector_node: No converter found for column public.postgres_single_types.c_enum of type unknown. The column will not be part of change events for that table. thread="debezium-postgresconnector-RW_CDC_5-change-event-source-coordinator" class="io.debezium.relational.TableSchemaBuilder"

The DBz is still querying with the old oid of the enum.
When you scan the newly create rw table, the c_enum will be NULL

Expected behavior

No response

How did you deploy RisingWave?

In any way.

The version of RisingWave

No response

Additional context

The best solution for now is restarting the RW cluster.