Postgres Pro
Downloads
Home   >   mailing lists

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

From Manlio Perillo
Subject non intuitive behaviour of DROP TABLE IF EXISTS
Date
Msg-id 4B8FE141.9010007@gmail.com
Whole thread Raw
Responses Re: non intuitive behaviour of DROP TABLE IF EXISTS  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Tree view 
-----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-----

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Auto VACUUM
Next
From: Scott Marlowe
Date:
Subject: Re: Scratching my head why results are different between machines.