Strange permission problem regarding pg_settings

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange permission problem regarding pg_settings
Date: 2003-12-10 07:05:28
Message-ID: 3C6F3986-2ADF-11D8-9FED-0050E4A0EE4F@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi

I installed a postgres-application (which was developed on debian
woody) on red hat 9 today, using the postgres 7.3 rpms from redhad.
One of my the triggers uses the pg_settings table (more precisely, it
updates that table to change the search_path temporarily). With the
postgres 7.3 (and 7.4 too) installed on my debian development system,
this worked fine. On redhat 9, however, I get an "pg_settings:
permission denied" error when my trigger is executed.

The same thing happens when I try altering the pg_settings table from
the commandline. (But of course works, when connected as superuser). I
double-checked the permissions set on both the pg_settings view, and
the set_config(text, text, bool)-function called from the update-rule
for pg_settings, and both seem to be correct (and the same as on the
debian machine).

As I needed to get the thing running, I now solved the problem by
making the user that my app connects as a superuser, but I'd like to
get rid of this again...

Are there any more permission I could check, or perhaps some
config-option in postgres.conf that I could try?

greetings, Florian Pflug

PS: I also tried moving the postgres-data-dir away, and creating a
fresh one with initdb - but with no success - still "pg_settings:
permission denied"

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bret Busby 2003-12-10 07:09:09 Re: [NOVICE] PostgreSQL Training
Previous Message Sai Hertz And Control Systems 2003-12-10 07:00:01 Re: Shell access & send email from PLPGSQL?

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-12-10 07:19:39 Re: Strange permission problem regarding pg_settings
Previous Message Christopher Kings-Lynne 2003-12-10 06:11:19 Re: Cannot add an column of type serial or bigserial