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. Have a good day James -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs