bash-2.05b$ ./psql newempty < file.txt SET You are now connected as new user rbt. SET REVOKE GRANT ERROR: dependent privileges exist (use CASCADE to revoke them too)
The above is from the result of loading the attached file (empty database) into "newempty" which is a different empty database. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
-- -- PostgreSQL database dump -- SET autocommit TO 'on'; \connect - rbt SET autocommit TO 'on'; -- -- TOC entry 2 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: rbt -- REVOKE ALL ON SCHEMA public FROM PUBLIC; -- -- TOC entry 3 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: rbt -- GRANT ALL ON SCHEMA public TO PUBLIC; -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: rbt -- REVOKE ALL ON SCHEMA public FROM rbt;
signature.asc
Description: This is a digitally signed message part
