Re: Warning: PostgreSQL query failed: ERROR: [my_tabel]:

On Fri, 9 Aug 2002, Barker wrote:

>
> Yes, the webserver is apache, and read/write permission is granted
> as seen below.
>
> The example below shows that the permission-denied problem happens
> in the Unix mode too for the apache user, but not for the postgres
> superuser.
>
> --------------------------------------------------------
> [root@linux5 octave]# psql --version
> psql (PostgreSQL) 7.2.1
> ...
>
> [root@linux5 octave]# psql -U apache octave
> Welcome to psql, the PostgreSQL interactive terminal.
> ...
>
> octave=> \z
> Access privileges for database "octave"
>  Table |       Access privileges
> -------+--------------------------------
>  form  | {=,postgres=arwdRxt,apache=rw}
>  use   | {=,postgres=arwdRxt,apache=rw}
> (2 rows)
>
> octave=> INSERT INTO use VALUES ('date', 'time', 'ip', 'port', 'Mozilla'
> );
> ERROR:  use: Permission denied.
>

Are you sure used GRANT correctly. I've checked on a fresh table and when I:

GRANT SELECT,INSERT ON fresh_table TO a_user;

I get \z showing:

fresh_table | {=,a_user=ar,the_creator=arwdRxt}

and a_user can happily insert.

Another possibility could be that there's a trigger doing something that is
giving rise to that error.


--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants