Re: Grant RULE removed in pg 8.2

Поиск
Список
Период
Сортировка
От Erwin Brandstetter
Тема Re: Grant RULE removed in pg 8.2
Дата
Msg-id 481BA022.2010201@falter.at
обсуждение исходный текст
Ответ на Re: Grant RULE removed in pg 8.2  ("Dave Page" <dpage@pgadmin.org>)
Ответы Re: Grant RULE removed in pg 8.2
Список pgadmin-support
dpage@pgadmin.org wrote:
> Fixed it is. Pleased you'll be.

Patience you shall need, master Dave!
Testing pgAdmin v.1.9.0-Dev (May 2 2008), rev: 7245:7266M, on WinXP; 
host: pg 8.2.7 and 8.3.1 on Debian Etch.

The "Privileges" dialog seems fixed. But the reverse engineered SQL doesn't:
If I say:   GRANT ALL ON TABLE test TO dummy;
then SQL pane says:   GRANT ALL ON TABLE test TO dummy;

But if I say:   GRANT ALL ON TABLE v_test TO dummy;      -- v_test being a VIEW
then SQL pane says:   GRANT SELECT, UPDATE, INSERT, DELETE, REFERENCES, TRIGGER ON TABLE 
v_test TO dummy;

The latter should read the same as the former.


Regards
Erwin


В списке pgadmin-support по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: MacOS X annoyances
Следующее
От: "SriHarsha Angara"
Дата:
Сообщение: Regarding Postgres and Active Directories.