| Lists: | pgsql-hackers |
|---|
| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | 7.2 to 7.4 upgrade issues |
| Date: | 2003-06-27 19:36:11 |
| Message-ID: | 1056742570.26491.4.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.2 to 7.4 upgrade issues |
| Date: | 2003-06-27 19:59:42 |
| Message-ID: | Pine.LNX.4.44.0306272158430.5890-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)gmx(dot)net
| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.2 to 7.4 upgrade issues |
| Date: | 2003-06-27 20:43:30 |
| Message-ID: | 1056746608.26491.10.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| Attachment | Content-Type | Size |
|---|---|---|
| test_724dump.sql | text/x-sql | 453 bytes |
| test_74dump.sql | text/x-sql | 528 bytes |
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Rod Taylor <rbt(at)rbt(dot)ca> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.2 to 7.4 upgrade issues |
| Date: | 2003-06-28 18:24:54 |
| Message-ID: | Pine.LNX.4.44.0306282019260.2178-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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(at)gmx(dot)net