Hello, When I do a "pgdump --schema=someschema somedatabase > something.dump", the results of the dump file look like this:
REVOKE ALL ON SCHEMA someschema FROM PUBLIC; GRANT ALL ON SCHEMA someschema TO PUBLIC; SET search_path = someschema, pg_catalog; CREATE SEQUENCE emailtemplate_email_templat_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; CREATE TABLE emailtemplates ( email_template_id integer DEFAULT nextval('"emailtemplate_email_templat_seq"'::text) NOT NULL, template_name character varying(16) NOT NULL, subject character varying(80) NOT NULL, plain_text text, html_block text, entered_dt timestamp with time zone, updated_dt timestamp with time zone ); ... This seems *extremely* problematic to me because unless explicitly set search_path, it is not possible to insert data (in this case into emailtemplates) because the sequence does not have the schema specified.... Am I using schemas wrong?.. Should I be to do "INSERT INTO someschema.emailtemplates" and expect it to work after restoring a database in this fashion?... I was really surprised to see this after having gone though extensive/ painstaking work to ensure that all of this was correct in my database conversion to have pgdump essentially undo all of this -- yikes.... So I am beginning to think that I must doing something wrong here.... - Greg ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org