Unexpected behavior of DROP VIEW/TABLE IF EXISTS

2018-06-26 17:23 GMT+02:00 Peter Moser <pitiz29a@gmail.com>:

Hi,
I want to delete a table X, that may not exist, hence I execute

        DROP TABLE IF EXISTS X;

However, if X is a view, I get an error

        ERROR: "X" is not a table

        HINT: Use DROP VIEW to remove a view.
        SQL state: 42809

That is unexpected and also difficult to handle

DROP TABLE should to remove table and nothing else, like DROP VIEW should to drop just view and nothing else. It is safeguard.