[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] BUG #7650: DROP TABLE IF EXISTS fails if schema does not exist
From:       Bruce Momjian <bruce () momjian ! us>
Date:       2013-06-29 3:09:20
Message-ID: 20130629030920.GL13790 () momjian ! us
[Download RAW message or body]

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. +


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]