wal2json icon indicating copy to clipboard operation
wal2json copied to clipboard

Provide a way to ignore `pg_temp_*` tables

Open blimmer opened this issue 5 years ago • 2 comments

I'd like to be able to filter all changes to pg_temp_* tables from wal2json messages. However, the existing filter-tables solution does not allow for wildcards within table names (see also https://github.com/eulerto/wal2json/issues/104#issuecomment-700924939).

blimmer avatar Sep 29 '20 21:09 blimmer

I'm back to this issue. Per your comment in the other issue, it doesn't seem a temporary table (temporary table uses a schema named pg_temp_XX). It seems a transient object to handle heap rewrites (such as a REFRESH MATERIALIZED VIEW or ALTER TABLE). The commit postgres/postgres@325f2ec5557fd1c9156c910102522e04cb42d99c fixed it for v11+. There is nothing to fix for temporary tables.

However, this issue is still valid for ignoring tables whose the name matches a pattern.

eulerto avatar Dec 14 '22 21:12 eulerto

Thanks for the heads up on the upstream fix!

blimmer avatar Dec 14 '22 22:12 blimmer