You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If your database has multiple schemas, and the base query detects one of these tables needs to be vacuumed, it fails because the schema-qualified table name is being wrapped in double quotes.
The failure looks like the following:
2022-08-09 14:20:52 UTC: VACUUM FREEZE ANALYZE "schema.table" in database dbname
2022-08-09 14:20:52 UTC: VACUUMing schema.table failed.
2022-08-09 14:20:52 UTC: relation "schema.table" does not exist
The text was updated successfully, but these errors were encountered:
Thanks for the report and the PR! There is definitely an issue here with tables that are not in search_path. The proposed PR would fail if a table had "A Name That Needs Quoting", so more work is required there. We'll see about fixing that.
If your database has multiple schemas, and the base query detects one of these tables needs to be vacuumed, it fails because the schema-qualified table name is being wrapped in double quotes.
The failure looks like the following:
The text was updated successfully, but these errors were encountered: