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 |
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 |