Re: strange permission error

Поиск
Список
Период
Сортировка
От Mr Dash Four
Тема Re: strange permission error
Дата
Msg-id 50695259.7060406@googlemail.com
обсуждение исходный текст
Ответ на Re: strange permission error  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: strange permission error  (John R Pierce <pierce@hogranch.com>)
Список 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.



В списке pgsql-general по дате отправления:

Предыдущее
От: "Marc Mamin"
Дата:
Сообщение: Re: Planner choice on NULLs (9.1.5) with 2 conditional indexes
Следующее
От: "Carrington, Matthew (Produban)"
Дата:
Сообщение: Re: pg_upgrade: out of memory