Re: [SQL] simple "select / if found" isn't - Mailing list pgsql-sql

From Karsten Hilbert
Subject Re: [SQL] simple "select / if found" isn't
Date
Msg-id 20161216112909.yt5q5nzvuewq5myi@hermes.hilbert.loc
Whole thread Raw
In response to Re: [SQL] simple "select / if found" isn't  (Gary Stainburn <gary.stainburn@ringways.co.uk>)
List 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 by date:

Previous
From: Gary Stainburn
Date:
Subject: Re: [SQL] simple "select / if found" isn't
Next
From: Jan Otto
Date:
Subject: Re: [SQL] simple "select / if found" isn't