dbTalk Databases Forums  

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

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4 in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Christoph Becker
 
Posts: n/a

Default [BUGS] 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4 - 08-16-2003 , 01:25 AM






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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.