Re: Unable to delete row on 7.3.2 with schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: Unable to delete row on 7.3.2 with schemas
Date
Msg-id 11600.1046819576@sss.pgh.pa.us
Whole thread Raw
In response to Unable to delete row on 7.3.2 with schemas  (Fernando Schapachnik <fernando@mecon.gov.ar>)
Responses Re: Unable to delete row on 7.3.2 with schemas  (Fernando Schapachnik <fernando@mecon.gov.ar>)
List pgsql-general
Fernando Schapachnik <fernando@mecon.gov.ar> writes:
> ERROR:  usr: permission denied

AFAIR, all our "permission denied" messages cite the object in question,
not the referencing user.  So this is complaining about access rights to
the "usr" schema.  You have not shown us enough information to guess why
this query would need to look into the "usr" schema --- but presumably
someone needs the USAGE right on "usr", and hasn't got it.

            regards, tom lane

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: pg and chroot (performance)
Next
From: Jason Larke
Date:
Subject: Re: Help with exporting data