By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,695 Members | 1,956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,695 IT Pros & Developers. It's quick & easy.

pg_catalog permission problem

P: n/a
I'm using Postgres 7.4. I have a database called tracking and user called
test5. From the Red Hat command line test5 can psql tracking and run:

SELECT * FROM Customers;

Not surprisingly, a list of customers is shown.

I have a Visual Basic application is accessing the same database. The same
user can open a connection to the same database. When the same query is run
the following error is thrown from Postgres:

permission denied for schema pg_catalog

With the connection to the database still open, I've run the foloowing query:

SHOW search_path;

And the following error message is returned:

permission denied for relation pg_type

Setting this user to usesuper=True in the pg_shadow table enables everything
to work correctly. But I obviously don't want to do that.

I've also tried:

GRANT ALL ON SCHEMA pg_catalog TO test5;
and
GRANT ALL ON SCHEMA pg_catalog TO PUBLIC;

and that doesn't seem to work.

Any ideas on where my permissions problem is? Is this something I missed in
the Postgres install? Could the Postgres process be running under an
inccorect user id?

I'd appreciate any help. Thanks...
Nov 22 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Chris Skaryd <CS*****@TheOPALGroup.com> writes:
I have a Visual Basic application is accessing the same database. The same
user can open a connection to the same database. When the same query is run
the following error is thrown from Postgres: permission denied for schema pg_catalog


Hmmm ... better find out what queries your VB application is really
issuing. Turning on query logging in postgresql.conf might be
illuminating.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #2

P: n/a
Tom,

Thanks for your response.

Once logging is turned on, the only message that shoes up in the log is this:

Jan 19 14:02:40 penguin postgres[5728]: [3-1] ERROR: permission denied for
relation pg_type

So, it seems to fail before the query is even run.

I changed the following settings:
debug_print_parse = true
debug_print_rewritten = true
debug_print_plan = true
debug_pretty_print = true

Chris

Tom Lane wrote:
Chris Skaryd <CS*****@TheOPALGroup.com> writes:
I have a Visual Basic application is accessing the same database. The same
user can open a connection to the same database. When the same query is run
the following error is thrown from Postgres:


permission denied for schema pg_catalog

Hmmm ... better find out what queries your VB application is really
issuing. Turning on query logging in postgresql.conf might be
illuminating.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #3

P: n/a
Tom,

I tried to reply to your email, but it was returned as "probable spam" citing
that Cable & Wireless was my provider. five-ten-sg.com blocks all email from
a major net provider when there are apparently a few spammers who use C&W. I
find that a little extreme.

Chris

Tom Lane wrote:
Chris Skaryd <CS*****@TheOPALGroup.com> writes:
I have a Visual Basic application is accessing the same database. The same
user can open a connection to the same database. When the same query is run
the following error is thrown from Postgres:


permission denied for schema pg_catalog

Hmmm ... better find out what queries your VB application is really
issuing. Turning on query logging in postgresql.conf might be
illuminating.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 22 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.