Query goal: | Find foreign data wrappers that do not have any associated foreign servers. |
Query type: | Problem detection (Each row in the result could represent a flaw in the design) |
Query reliability: | High (Few or no false-positive results) |
Query license: | MIT License |
Fixing suggestion: | Drop the foreign data wrapper or start to use it. |
Data source: | INFORMATION_SCHEMA only |
SQL query: | Click on query to copy it
SELECT foreign_data_wrapper_name FROM INFORMATION_SCHEMA.foreign_data_wrappers AS fdw WHERE NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.foreign_servers AS fs WHERE fdw.foreign_data_wrapper_name=fs.foreign_data_wrapper_name) ORDER BY foreign_data_wrapper_name; |
SQL query | Description |
---|---|
SELECT format('DROP FOREIGN DATA WRAPPER %1$I;', foreign_data_wrapper_name) AS statements FROM INFORMATION_SCHEMA.foreign_data_wrappers AS fdw WHERE NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.foreign_servers AS fs WHERE fdw.foreign_data_wrapper_name=fs.foreign_data_wrapper_name) ORDER BY foreign_data_wrapper_name; | Drop the foreign data wrapper. |
Collection name | Collection description |
---|---|
Find problems automatically | Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not . |
Category name | Category description |
---|---|
Distributed database | Queries of this category provide information about the foreign table mechanism. |
Unused implementation elements | Queries of this catergory provide information about the database objects that are not used. |
Reference |
---|
https://wiki.postgresql.org/wiki/Foreign_data_wrappers |