Re: non intuitive behaviour of DROP TABLE IF EXISTS - Mailing list pgsql-general

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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do