pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: postgresql.2020@t-net.ruhr
Subject: BUG #16492: DROP VIEW IF EXISTS error
Date: Fri, 12 Jun 2020 17:47:12 +0000
Message-ID: <16492-2f002961054fd4a8@postgresql.org> (raw)

The following bug has been logged on the website:

Bug reference:      16492
Logged by:          Nina Marlow
Email address:      postgresql.2020@t-net.ruhr
PostgreSQL version: 12.3
Operating system:   Linux/Docker
Description:        

When trying to use "DROP VIEW IF EXISTS x" while a table named "x" exists,
the DROP statement raises an "Error: x is not a view".

The documentation says about the "IF EXISTS" clause:

> Do not throw an error if the view does not exist. A notice is issued in
this case.

Imho, there shouldn't be an error if the view does not exist regardless of
whether or not a table with this name exists. The observed behavior is
contrary to the sense of the "IF EXISTS" clause as one would have to check
whether a table with the desired name exists before using "DROP VIEW IF
EXISTS". But then you could directly check whether or not the view itself
exists.

The error is, of course, absolutely correct for the "DROP VIEW" (without "IF
EXISTS") statement.

But when using "IF EXISTS", it can be a big problem if the statement is part
of a longer batch of statements because the batch operation stops on the
error.



view thread (17+ messages)  latest in thread

Message-ID: <16492-2f002961054fd4a8@postgresql.org>
Permalink:  ../16492-2f002961054fd4a8@postgresql.org/
Also on:    postgresql.org/message-id/16492-2f002961054fd4a8@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, postgresql.2020@t-net.ruhr
  Subject: Re: BUG #16492: DROP VIEW IF EXISTS error
  In-Reply-To: <16492-2f002961054fd4a8@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox