Re: strange permission error

On 10/01/12 1:20 AM, Mr Dash Four wrote:
>> 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.

that doesn't make any sense at all.

'user: ' *is* text by default. I didn't notice you displaying your
table definitions, but assuming u_name is TExT or VARCHAR(...) it
should have worked without any explicit casts

if you broke the permissions on the pg_catalog so badly that the SQL
planner can't look up the data types of the fields of your own tables,
well, thats just wrong.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast