Thread: 7.2 to 7.4 upgrade issues
Using the 7.4 pg_dump to dump a 7.2 database, restoration to 7.4 causes: REVOKE GRANT 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. -- Rod Taylor <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
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. -- Peter Eisentraut peter_e@gmx.net
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 <rbt@rbt.ca> PGP Key: http://www.rbt.ca/rbtpub.asc
Attachment
Rod Taylor writes: > Attached is a 7.2.4 dump (loads without error) and a 7.4 dump (loads > with error). OK, pg_dump wasn't taking into account that earlier versions didn't have grant options. I'll fix it. -- Peter Eisentraut peter_e@gmx.net