Re: 7.2 to 7.4 upgrade issues - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: 7.2 to 7.4 upgrade issues
Date
Msg-id 1056746608.26491.10.camel@jester
Whole thread Raw
In response to Re: 7.2 to 7.4 upgrade issues  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: 7.2 to 7.4 upgrade issues
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 7.2 to 7.4 upgrade issues
Next
From: Adam Haberlach
Date:
Subject: Manual fixing of plpgsql_call_handler binary location -- good idea?