On Sun, Nov 11, 2012 at 03:17:34PM +0000, j...@zer7.com wrote: > The following bug has been logged on the website: > > Bug reference: 7650 > Logged by: James Bellinger > Email address: j...@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 <br...@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
