Re: 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could
От | Bruce Momjian |
---|---|
Тема | Re: 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could |
Дата | |
Msg-id | 200309042324.h84NOFD12704@candle.pha.pa.us обсуждение исходный текст |
Ответ на | 7.4beta1, Error in dumpall from 7.3.4 since CASCADE could not be used in REVOKE in 7.3.4 (Christoph Becker <CGBecker@gmx.de>) |
Список | pgsql-bugs |
Has this been addressed? --------------------------------------------------------------------------- Christoph Becker wrote: > 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 > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-bugs по дате отправления: