Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cHqf4-00077U-NY for pgsql-sql@arkaria.postgresql.org; Fri, 16 Dec 2016 11:26:50 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cHqf3-0007sM-Vj for pgsql-sql@arkaria.postgresql.org; Fri, 16 Dec 2016 11:26:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cHqe5-0006l3-2i for pgsql-sql@postgresql.org; Fri, 16 Dec 2016 11:25:49 +0000 Received: from hub.ringways.co.uk ([88.211.105.30] helo=ringways.co.uk) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cHqe2-0000DT-G8 for pgsql-sql@postgresql.org; Fri, 16 Dec 2016 11:25:48 +0000 Received: from eddie.ringways.co.uk ([10.1.1.115]) by ringways.co.uk with esmtp (Exim 4.84_2) (envelope-from ) id 1cHqcz-000R2k-PJ for pgsql-sql@postgresql.org; Fri, 16 Dec 2016 11:24:42 +0000 From: Gary Stainburn Organization: Ringways Garages Ltd To: pgsql-sql@postgresql.org Subject: Re: simple "select / if found" isn't Date: Fri, 16 Dec 2016 11:24:41 +0000 User-Agent: KMail/1.9.10 References: <201612161102.37559.gary.stainburn@ringways.co.uk> <20161216111212.edknff56d52bgrjl@hermes.hilbert.loc> In-Reply-To: <20161216111212.edknff56d52bgrjl@hermes.hilbert.loc> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <201612161124.41580.gary.stainburn@ringways.co.uk> X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 106707 [Dec 16 2016] X-KLMS-AntiSpam-Version: 5.7.0.14 X-KLMS-AntiSpam-Envelope-From: gary.stainburn@ringways.co.uk X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 157 157 9c31c0476def61774fb291ea4183b61c3a0839e5, {msgid_created_by_recepient}, 127.0.0.200:5.2.1;d41d8cd98f00b204e9800998ecf8427e.com:7.1.1;eddie.ringways.co.uk:7.1.1;127.0.0.199:7.1.2,5.2.1;ringways.co.uk:7.1.1 X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2016/12/15 10:39:48 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2016/12/16 04:06:00 #8492275 X-KLMS-AntiVirus-Status: Clean, skipped X-Spam-Score: -53.9 (---------------------------------------------------) X-Spam-Report: Spam detection software, running on the system "ollie2.ringways.co.uk", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see Gary Stainburn for details. Content preview: On Friday 16 December 2016 11:12:13 Karsten Hilbert 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. > > A shot in the dark... > > Karsten [...] Content analysis details: (-53.9 points, 15.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -50 ALL_TRUSTED Passed through trusted hosts only via SMTP 0.1 SCORE_RCPTS Adding score for each recipient -3.1 RP_MATCHES_RCVD Envelope sender domain matches handover relay domain -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] 1.0 RING_SAFE No description available. X-forward-disable: yes X-Pg-Spam-Score: -5.0 (-----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org On Friday 16 December 2016 11:12:13 Karsten Hilbert 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. > > A shot in the dark... > > Karsten Thank you for the reply, but I'm not sure what you mean. To give more context (which I should have not straight off) I'm on an old box which is running PoshgreSQL 8.3 for both the server and client (psql). The select from table, create function, and select from function are all happening in the same psql sesson, logged in the owner of the database. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql