Re: simple "select / if found" isn't

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: simple "select / if found" isn't
Date: 2016-12-16 11:29:09
Message-ID: 20161216112909.yt5q5nzvuewq5myi@hermes.hilbert.loc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Otto 2016-12-16 11:34:48 Re: simple "select / if found" isn't
Previous Message Gary Stainburn 2016-12-16 11:24:41 Re: simple "select / if found" isn't