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

From Rob Sargent
Subject Re: [GENERAL] looking for a globally unique row ID
Date
Msg-id 2b934341-b546-a4d3-2316-0cd6ed1a6812@gmail.com
Whole thread Raw
In response to Re: [GENERAL] looking for a globally unique row ID  (Adam Brusselback <adambrusselback@gmail.com>)
Responses Re: [GENERAL] looking for a globally unique row ID
List pgsql-general



On 09/15/2017 12:45 PM, Adam Brusselback wrote:
I cannot image a single postgres index covering more than one physical table. Are you really asking for that?

While not available yet, that is a feature that has had discussion before.  Global indexes are what i've seen it called in those discussions.  One of the main use cases is to provide uniqueness across multiple tables, which would also allow things like foreign keys on partitioned tables.
I had a sneaking suspicion that partitioning would be the use-case, but clearly there's at least the 'notion' of a single entity

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID
Next
From: Christopher Browne
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID