non intuitive behaviour of DROP TABLE IF EXISTS

From: Manlio Perillo <manlio(dot)perillo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: non intuitive behaviour of DROP TABLE IF EXISTS
Date: 2010-03-04 16:35:13
Message-ID: 4B8FE141.9010007@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----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

Thanks Manlio
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkuP4UEACgkQscQJ24LbaURLWQCfVoKqOdnIzX0asSTbDnMJXV8M
WzoAniLEibeav+KLm6LbhWhxIiJWSGMG
=X1nb
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-03-04 17:04:06 Re: Scratching my head why results are different between machines.
Previous Message Joshua D. Drake 2010-03-04 16:34:13 Re: Auto VACUUM