Re: [GENERAL] looking for a globally unique row ID - Mailing list pgsql-general

From John R Pierce
Subject Re: [GENERAL] looking for a globally unique row ID
Date
Msg-id 323fe3e3-41d1-313a-5253-dc47f2e5a31c@hogranch.com
Whole thread Raw
In response to [GENERAL] looking for a globally unique row ID  (Rafal Pietrak <rafal@ztk-rp.eu>)
List 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 by date:

Previous
From: Rafal Pietrak
Date:
Subject: [GENERAL] looking for a globally unique row ID
Next
From: Michael Paquier
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID