it is at connect-time, so there is nothing done with set session authorization.
I just want to connect, and read data from a table to which the group the
user is in has read-access.
I have tried if it would differ when I try to connect with a user created like:
CREATE USER 20020003 WITH ENCRYPTED PASSWORD 'secret';
or
CREATE USER 20020004 WITH UNENCRYPTED PASSWORD 'secred';
it would not matter... even if there really is a trust-relation between my
computer and the other machine in pg_hba.conf
it is pretty strange... might it be a bug?
Thanks for the try though,
Michiel
At 19:42 26-1-2003 -0500, Tom Lane wrote:
>Michiel Lange <michiel(at)minas(dot)demon(dot)nl> writes:
> > I get this error message:
> > psql: FATAL: permission denied
>
>As near as I can tell, you must have some code that is trying to do
>SET SESSION AUTHORIZATION --- which only a superuser is allowed to do.
>Evidently user 20020003 isn't one.
>
> regards, tom lane