Re: Strange permission problem regarding pg_settings

Florian G. Pflug wrote:
> 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.

I've got Red Hat 9 here, but it is hard to guess what might be wrong
without seeing some details. Can you post a self-contained example that
recreates the problem?

Joe