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
27 Jun 2003 15:36:11 -0400
Rod Taylor <rbt@rbt.ca>
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


Fri, 27 Jun 2003 21:59:42 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: 7.2 to 7.4 upgrade issues
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
27 Jun 2003 16:43:30 -0400
Rod Taylor <rbt@rbt.ca>
Re: 7.2 to 7.4 upgrade issues
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


Sat, 28 Jun 2003 20:24:54 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: 7.2 to 7.4 upgrade issues