On Thu, 14 Sep 2017 09:45:59 +0200, Rafal Pietrak <rafal@xxxxxxxxx> wrote: >Hello everybody, > >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. UUID is the obvious choice, but it does take a lot of space. Something like this might do the job: http://rob.conery.io/2014/05/28/a-better-id-generator-for-postgresql/ George -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
