Skip site navigation (1) Skip section navigation (2)

Re: Grant RULE removed in pg 8.2

From: Erwin Brandstetter <brandstetter(at)falter(dot)at>
To: dpage(at)pgadmin(dot)org
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Grant RULE removed in pg 8.2
Date: 2008-05-02 23:13:38
Message-ID: 481BA022.2010201@falter.at (view raw or flat)
Thread:
Lists: pgadmin-support
dpage(at)pgadmin(dot)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

In response to

Responses

pgadmin-support by date

Next:From: SriHarsha AngaraDate: 2008-05-03 00:48:13
Subject: Regarding Postgres and Active Directories.
Previous:From: Dave PageDate: 2008-04-29 08:41:08
Subject: Re: MacOS X annoyances

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group