On Thu, Sep 14, 2017 at 4:45 PM, Rafal Pietrak <ra...@ztk-rp.eu> 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. > [...] > I'd appreciate any hints, as I'm bitting my head against this problem > for a long time, now.
UUID would give you some room for requirement 1. 2 and 3 can be found with the usage of a serial column. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
