| 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 |
| Thread: | |
| 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 | Date | Subject | |
|---|---|---|---|
| Next Message | Adam Haberlach | 2003-06-27 21:07:47 | Manual fixing of plpgsql_call_handler binary location -- good idea? |
| Previous Message | Peter Eisentraut | 2003-06-27 19:59:42 | Re: 7.2 to 7.4 upgrade issues |