Re: Problem with 7.4.5 and webmin 1.8 in grant function

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: amrit(at)health2(dot)moph(dot)go(dot)th, PGsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
Date: 2005-02-21 21:51:16
Message-ID: 421A57D4.2070801@coretech.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Mark Kirkwood wrote:
> If on the other hand you can do *some* Pg admin from webmin, and you are
> only having problems with the grants then there is something it does not
> like about the *particular* statement. The way to debug this is to do a
> tiny perl DBI program that tries to execute the statement :
>
> select relname, relacl from pg_class where (relkind = 'r' OR relkind =
> 'S') and relname !~ '^pg_' order by relname
>

I did a quick check of this case... seems to be no problem running this
statement using perl 5.8.5, DBI-1.42 and DBD-Pg-1.22. You might like to
try out the attached test program that does this (You may have to add a
password in order to connect, depending on your security settings).

Mark

Attachment Content-Type Size
relacl.pl text/plain 731 bytes

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ron Mayer 2005-02-22 01:14:19 Re: seq scan cache vs. index cache smackdown
Previous Message Mark Kirkwood 2005-02-21 21:16:06 Re: Problem with 7.4.5 and webmin 1.8 in grant function