Postgres Pro
Downloads
Home   >   mailing lists

7.2 to 7.4 upgrade issues - Mailing list pgsql-hackers

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

pgsql-hackers by date:

Previous
From: Aizaz Ahmed
Date:
Subject: Re: pg_guc
Next
From: Peter Eisentraut
Date:
Subject: Missing array support