Manlio Perillo wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi. > > I think the following behaviour is not intuitive: > > manlio=> DROP TABLE IF EXISTS foo.bar; > ERROR: schema "foo" does not exist > > The statement should not fail if the schema does not exist Hmm. Well, it says TABLE IF EXISTS, not TABLE AND SCHEMA IF EXISTS. ;-) Not sure if it makes sense to change it. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
