Postgres Pro
Downloads
Home   >   mailing lists

Re: pervasiveness of surrogate (also called synthetic) keys - Mailing list pgsql-general

From Jeff Davis
Subject Re: pervasiveness of surrogate (also called synthetic) keys
Date
Msg-id 1304457096.6858.155.camel@jdavis-ux.asterdata.local
Whole thread Raw
In response to Re: pervasiveness of surrogate (also called synthetic) keys  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: pervasiveness of surrogate (also called synthetic) keys  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-general
Tree view 
On Mon, 2011-05-02 at 23:07 -0400, Greg Smith wrote:
> I see this whole area as being similar to SQL injection.  The same way
> that you just can't trust data input by the user to ever be secure, you
> can't trust inputs to your database will ever be unique in the way you
> expect them to be.

So, don't trust them to be unique then. Make up your own unique
identifier, and use that.

Regards,
    Jeff Davis

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres segfaulting on pg_restore
Next
From: dabicho
Date:
Subject: Question on Wal time lines