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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do