Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cJMxh-0001Dg-Gp for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Dec 2016 16:08:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cJMxg-0000sw-EY for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Dec 2016 16:08:20 +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 1cJMxe-0000rQ-GE for pgsql-hackers@postgresql.org; Tue, 20 Dec 2016 16:08:18 +0000 Received: from 173-164-140-181-sfba.hfc.comcastbusiness.net ([173.164.140.181] helo=fetter.org) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cJMxT-0005Mn-G7 for pgsql-hackers@postgresql.org; Tue, 20 Dec 2016 16:08:17 +0000 Received: by fetter.org (Postfix, from userid 1000) id 7FBB2E0661; Tue, 20 Dec 2016 08:08:01 -0800 (PST) Date: Tue, 20 Dec 2016 08:08:01 -0800 From: David Fetter To: Stephen Frost Cc: Heikki Linnakangas , Robert Haas , Peter Eisentraut , Michael Paquier , Andres Freund , David Steele , Tom Lane , Alvaro Herrera , Magnus Hagander , Julian Markwort , PostgreSQL mailing lists , Valery Popov Subject: Re: pg_authid.rolpassword format (was Re: Password identifiers, protocol aging and SCRAM protocol) Message-ID: <20161220160801.GA7806@fetter.org> References: <2d07165c-1793-e243-a2a9-e45b624c7580@iki.fi> <20161214145723.GJ23417@tamriel.snowman.net> <9dc32483-b24a-5832-53e0-fb62838f1315@iki.fi> <20161215134030.GI23417@tamriel.snowman.net> <5ec22c98-16b9-4d13-a551-9aa46d8f1269@iki.fi> <20161220133419.GX18360@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20161220133419.GX18360@tamriel.snowman.net> User-Agent: Mutt/1.7.1 (2016-10-04) X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On Tue, Dec 20, 2016 at 08:34:19AM -0500, Stephen Frost wrote: > Heikki, > > * Heikki Linnakangas (hlinnaka@iki.fi) wrote: > > Even if you have a separate "verifier type" column, it's not fully > > normalized, because there's still a dependency between the > > verifier and verifier type columns. You will always need to look > > at the verifier type to make sense of the verifier itself. > > That's true- but you don't need to look at the verifier, or even > have *access* to the verifier, to look at the verifier type. Would a view that shows only what's to the left of the first semicolon suit this purpose? Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers