Postgres CDC: upstream table in different schema will sync into same Table

[StrikeW]

Describe the bug

There are two tables named t2 in different schema, both of them will be synced into the same RW table created via sql:
create table t2a (...) from pg_source table 'public.t2'. This is unexpected, since t2a only need data from public.t2.

mydb=#  select * from pg_publication_tables;
    pubname     | schemaname | tablename
----------------+------------+-----------
 rw_publication | abs        | t2
 rw_publication | public     | t2
(4 rows)

Error message/log

No response

To Reproduce

No response

Expected behavior

No response

How did you deploy RisingWave?

No response

The version of RisingWave

v1.9.2

Additional context

No response

[github-actions]

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

[hzxa21]

@StrikeW Is this issue fixed?

[StrikeW]

@StrikeW Is this issue fixed?

No yet.