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@liquidprivacy.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.