On Sun, Nov 11, 2012 at 03:17:34PM +0000, [email protected] wrote: > The following bug has been logged on the website: > > Bug reference: 7650 > Logged by: James Bellinger > Email address: [email protected] > 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 <[email protected]> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
