Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Provide a way to ignore pg_temp_* tables #182

Open
blimmer opened this issue Sep 29, 2020 · 2 comments
Open

Provide a way to ignore pg_temp_* tables #182

blimmer opened this issue Sep 29, 2020 · 2 comments
Labels

Comments

@blimmer
Copy link

blimmer commented Sep 29, 2020

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 #104 (comment)).

@eulerto
Copy link
Owner

eulerto commented Dec 14, 2022

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@325f2ec 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.

@blimmer
Copy link
Author

blimmer commented Dec 14, 2022

Thanks for the heads up on the upstream fix!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants