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
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 |