Re: [GENERAL] restoring a database to its initial state

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tom Lane ha scritto: > Pavel Stehule writes: >> 2010/3/13 Manlio Perillo : >>> Usually when I need to restore a database to its initial state, what I >>> do is to simply drop it, and then re-create it. >>> How

[GENERAL] restoring a database to its initial state

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. Usually when I need to restore a database to its initial state, what I do is to simply drop it, and then re-create it. However on a shared hosting this is not possible. By initial state I mean: The content of template1 database or The databa

[GENERAL] non intuitive behaviour of DROP TABLE IF EXISTS

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