7.2 to 7.4 upgrade issues

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

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