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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Grant RULE removed in pg 8.2



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group