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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgadmin-support by date

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