Re: strange permission error

From: Mr Dash Four <mr(dot)dash(dot)four(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: strange permission error
Date: 2012-10-01 08:20:41
Message-ID: 50695259.7060406@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> You caused it yourself, then. Don't do that. (Or if you must,
> it's your own responsibility to fix things when they break. But
> preventing read access to pg_catalog seems pretty crippling.)
>
I don't want arbitrary program to have access to the system catalogue
and read willy-nilly, thanks.

> FWIW, it's probably the "'user: ' || u_name" expressions that result
> in this specific failure.
>
I found what is the cause of this - I had to add an explicit cast on all
text expressions, like "user: "::text as well as u_name::text. That way
the problem goes away, so it should.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2012-10-01 08:35:58 Re: opened connection
Previous Message Marc Mamin 2012-10-01 08:06:56 Re: Planner choice on NULLs (9.1.5) with 2 conditional indexes