non intuitive behaviour of DROP TABLE IF EXISTS

Manlio Perillo <manlio.perillo@xxxxxxxxx> · Thu, 04 Mar 2010 17:35:13 +0100

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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general