Attached is a 7.2.4 dump (loads without error) and a 7.4 dump (loads with error).
Create user "rbt" prior to loading either. Creation of the database was done by: rbttest=# create table tab (col integer); CREATE rbttest=# grant all on tab to public; GRANT On Fri, 2003-06-27 at 15:59, Peter Eisentraut wrote: > Rod Taylor writes: > > > psql:22.sql:2324: ERROR: dependent privileges exist (use CASCADE to > > revoke them too) > > > > Line 2324 is: > > REVOKE ALL ON TABLE sh2bill_action_action_id_seq FROM rbt; > > > > This user was the owner of of the sequence on the old database. > > I'd need to see a complete and standalone example. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc
-- -- Selected TOC Entries: -- \connect - rbt -- -- TOC Entry ID 2 (OID 38276387) -- -- Name: tab Type: TABLE Owner: rbt -- CREATE TABLE "tab" ( "col" integer ); -- -- TOC Entry ID 3 (OID 38276387) -- -- Name: tab Type: ACL Owner: -- REVOKE ALL on "tab" from PUBLIC; GRANT ALL on "tab" to PUBLIC; GRANT ALL on "tab" to "rbt"; -- -- Data for TOC Entry ID 4 (OID 38276387) -- -- Name: tab Type: TABLE DATA Owner: rbt -- COPY "tab" FROM stdin; \.
--
-- PostgreSQL database dump
--
\connect - rbt
--
-- TOC entry 2 (OID 38276387)
-- Name: tab; Type: TABLE; Schema: ; Owner: rbt
--
CREATE TABLE tab (
col integer
);
--
-- TOC entry 3 (OID 38276387)
-- Name: tab; Type: ACL; Schema: ; Owner: rbt
--
REVOKE ALL ON TABLE tab FROM PUBLIC;
GRANT ALL ON TABLE tab TO PUBLIC;
REVOKE ALL ON TABLE tab FROM rbt;
GRANT ALL ON TABLE tab TO rbt;
--
-- Data for TOC entry 4 (OID 38276387)
-- Name: tab; Type: TABLE DATA; Schema: ; Owner: rbt
--
COPY tab (col) FROM stdin;
\.
signature.asc
Description: This is a digitally signed message part
