Re: [SQL] simple "select / if found" isn't

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: [SQL] simple "select / if found" isn't
Дата
Msg-id 20161216112909.yt5q5nzvuewq5myi@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: [SQL] simple "select / if found" isn't  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
Список pgsql-sql
On Fri, Dec 16, 2016 at 11:24:41AM +0000, Gary Stainburn wrote:

> > If the function somehow got installed as "security definer"
> > and definer does not have RLS-based (!) permissions on
> > user_previous_passwords then it won't find rows.
> 
> To give more context (which I should have not straight off)
> 
> I'm on an old box which is running PostgreSQL 8.3 for both the server

That would preclude the RLS idea :-/

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346



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

Предыдущее
От: Gary Stainburn
Дата:
Сообщение: Re: [SQL] simple "select / if found" isn't
Следующее
От: Jan Otto
Дата:
Сообщение: Re: [SQL] simple "select / if found" isn't