Skip site navigation (1) Skip section navigation (2)

Re: Guarantee uniqueness of PGP key

From: andre <andre(at)liquidprivacy(dot)net>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: pgsql-sql(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Guarantee uniqueness of PGP key
Date: 2002-05-21 11:56:16
Message-ID: 20020521115616.C87C780269@pepe.lfcity.org (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
Yes, I've decided to relax the unique-ness constraint on the public key.  The 
email address is still guaranteed unique. And we send out an encrypted 
verification email that only the person with the private key can decrypt and 
respond to. Thus, it doesn't really hurt to have multiple people paste in the 
same pub key.

If I really wanted uniqueness, I think you (and the others who replied) are 
correct that I should be storing the 'fingerprint' in a separate column.

/andre  

On Tuesday 21 May 2002 06:54 am, Bruno Wolff III wrote:
> On Mon, May 20, 2002 at 15:17:09 -0500,
>
>   andre <andre(at)liquidprivacy(dot)net> wrote:
> > The problem is that some PGP keys are over 2713 bytes, and postgres (7.2)
> > gives the error:
>
> You might want to rethink your design. You probably want just the RSA or
> DSA public key to be unique. Otherwise you will treat different versions of
> what is essentially the same key as being different. (This might be due
> to be signed by a different set of keys.) I suspect that this isn't what
> you want. I think even the craziest people are using keys that should
> be around 1000 bytes. Paranoid people (or those needing very long lived
> public keys) are using ones half that size.

In response to

pgsql-novice by date

Next:From: WimDate: 2002-05-21 13:16:44
Subject: Problem with inserting: attribute 'extended_reason'
Previous:From: Bruno Wolff IIIDate: 2002-05-21 11:54:42
Subject: Re: Guarantee uniqueness of PGP key

pgsql-sql by date

Next:From: Joel BurtonDate: 2002-05-21 13:10:10
Subject: Re: drop constraint problem
Previous:From: Bruno Wolff IIIDate: 2002-05-21 11:54:42
Subject: Re: Guarantee uniqueness of PGP key

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group