The following bug has been logged on the website: Bug reference: 7515 Logged by: James Bellinger Email address: ja...@illusorystudios.com PostgreSQL version: 9.1.5 Operating system: Ubuntu Linux 12.04 Server Description:
If the table being referenced has a schema in its name, and the schema does not exist, DROP TABLE IF EXISTS will have an ERROR instead of a NOTICE. So for instance, DROP TABLE IF EXISTS bar; This is a NOTICE if bar does not exist. DROP TABLE IF EXISTS foo.bar; This is an ERROR if foo does not exist, even though that implies bar does not exist which means it should be a NOTICE. Saw this because it was making a drop/recreate transaction fail on me, after I changed some code to use a schema. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
