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

From Bruce Momjian
Subject Re: BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist
Date
Msg-id 20130629030920.GL13790@momjian.us
Whole thread Raw
In response to BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist  (jfb@zer7.com)
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. +

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #7636: \ef doesn't honor ON_ERROR_ROLLBACK
Next
From: emre@hasegeli.com
Date:
Subject: BUG #8271: Configure warning: sys/ucred.h: present but cannot be compiled