Re: BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist - Mailing list pgsql-bugs

On Sun, Nov 11, 2012 at 03:17:34PM +0000, jfb@zer7.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      7650
> Logged by:          James Bellinger
> Email address:      jfb@zer7.com
> PostgreSQL version: 9.1.5
> Operating system:   Ubuntu Linux 12.04 Server
> Description:
>
> Not sure this worked last time (I got some DMARC error), but here's a
> bug...
>
> If a schema does not exist, DROP TABLE IF EXISTS schema.table will cause the
> transaction to fail (due to 'schema does not exist'). End result, DROP TABLE
> IF EXISTS is pretty much unusable with schemas. It needs to act the same as
> DROP TABLE IF EXISTS does for the default schema.

FYI, this will be fixed in Postgres 9.3.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +