Re: pervasiveness of surrogate (also called synthetic) keys

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: pervasiveness of surrogate (also called synthetic) keys
Дата
Msg-id 1304457096.6858.155.camel@jdavis-ux.asterdata.local
обсуждение исходный текст
Ответ на Re: pervasiveness of surrogate (also called synthetic) keys  (Greg Smith <greg@2ndQuadrant.com>)
Ответы Re: pervasiveness of surrogate (also called synthetic) keys
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgres segfaulting on pg_restore
Следующее
От: dabicho
Дата:
Сообщение: Question on Wal time lines