Re: [GENERAL] looking for a globally unique row ID

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [GENERAL] looking for a globally unique row ID
Дата
Msg-id 323fe3e3-41d1-313a-5253-dc47f2e5a31c@hogranch.com
обсуждение исходный текст
Ответ на [GENERAL] looking for a globally unique row ID  (Rafal Pietrak <rafal@ztk-rp.eu>)
Список pgsql-general
On 9/14/2017 12:45 AM, Rafal Pietrak wrote:
> Can anybody help me find a way to implement an ID which:
>
> 1. guarantees being unique across multiple tables.
>
> 2. guarantees its uniqueness not only during INSERT, but also during the
> lifetime of the database/application (e.i. during future UPDATES).
>
> 3. guarantees persistence of value across database backup/restore/upgrade.


isn't that the problem that GUID are supposed to answer ?


-- 
john r pierce, recycling bits in santa cruz



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Rafal Pietrak
Дата:
Сообщение: [GENERAL] looking for a globally unique row ID
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID