| From: | Joe Conway <mail(at)joeconway(dot)com> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Strange permission problem regarding pg_settings |
| Date: | 2003-12-10 07:19:39 |
| Message-ID: | 3FD6C90B.10302@joeconway.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dirk Försterling | 2003-12-10 07:22:22 | Re: ERRORs after upgrade from 7.2.1 to 7.4 about nonexisting |
| Previous Message | Joe Conway | 2003-12-10 07:16:13 | Re: Determining what a user can access |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Freislich | 2003-12-10 07:58:56 | Re: Cannot add an column of type serial or bigserial |
| Previous Message | Florian G. Pflug | 2003-12-10 07:05:28 | Strange permission problem regarding pg_settings |