From: Mark Kirkwood <markir@coretech.co.nz>
To: amrit@health2.moph.go.th
Cc: PGsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
Date: Mon, 21 Feb 2005 11:58:43 +1300
Message-ID: <42191623.7060401@coretech.co.nz> (raw)
In-Reply-To: <1108914570.4218b18a2cf0d@webmail.moph.go.th>
References: <1108914570.4218b18a2cf0d@webmail.moph.go.th>
amrit@health2.moph.go.th wrote:
> I newly installed the postgresql 7.4.5 and FC 3 in my server and transfer the
> data from 7.3.2 with just a few problems. After I use the webmin 1.8 to config
> the grant previllage to the users ,I found that there is an error in the grant
> previlege .
> postgresql --> Grant Previlege --> error
>
> select relname, relacl from pg_class where (relkind = 'r' OR relkind = 'S') and
> relname !~ '^pg_' order by relname : Unknown DBI error
>
> What is the cause of this error and how could I handle this order?
> Please make any comment, Thanks.
>
I would suspect a DBI/DBD installation issue, either perl DBI cannot
find DBD-Pg (not installed ?) or DBD-Pg cannot find your Pg 7.4.5.
I note that FC3 comes with Pg 7.4.6 - did you installed 7.4.5 from
source? If so this could be why the perl database modules cannot find it
(you may need to rebuild DBD-Pg, telling it where your Pg install is).
regards
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@coretech.co.nz, amrit@health2.moph.go.th
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
In-Reply-To: <42191623.7060401@coretech.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox