Re: BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist

On Sun, Nov 11, 2012 at 03:17:34PM +0000, jfb(at)zer7(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7650
> Logged by: James Bellinger
> Email address: jfb(at)zer7(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

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