7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4

From: Christoph Becker <CGBecker(at)gmx(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4
Date: 2003-08-15 20:54:11
Message-ID: 200308152254.11733.CGBecker@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following table was created in PostgreSQL 7.3.4

create table dummy_groupmember_is_admin
(bemerkung varchar(20));
GRANT SELECT, UPDATE, INSERT ON dummy_groupmember_is_admin TO GROUP admin;
REVOKE ALL ON dummy_groupmember_is_admin FROM cb,postgres;

If I read in the dumpall from the PostgreSQL 7.3.4 database with PostgreSQL
7.4beta1 I get an error and the Hint that I should use CASCADE.
The error line number points to:
REVOKE ALL ON dummy_groupmember_is_admin FROM cb,postgres;

But if I want to use CASCADE in PostgreSQL 7.3.4, I get a parse error.

Indeed, the manual of 7.3.4 does only mention CASCADE with REVOKE in a note
about SQL-92 compatibility, while the manual from 7.4beta1 shows that CASCADE
is an optional part of the REVOKE command.

Regards
Christoph Becker

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2003-08-15 21:17:37 Re: DBD::Pg 'lo_read' fails on >= 32768 byte large objects
Previous Message Kevin Houle 2003-08-15 20:19:22 Re: DBD::Pg 'lo_read' fails on >= 32768 byte large objects