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

From Rafal Pietrak
Subject Re: [GENERAL] looking for a globally unique row ID
Date
Msg-id ea03ec8e-9997-5ffd-681f-2924f2fc646a@ztk-rp.eu
Whole thread Raw
In response to Re: [GENERAL] looking for a globally unique row ID  (Jehan-Guillaume de Rorthais <ioguix@free.fr>)
Responses Re: [GENERAL] looking for a globally unique row ID  ("Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
List pgsql-general

W dniu 16.09.2017 o 09:33, Jehan-Guillaume de Rorthais pisze:
> 
[-------------]
> 
> I wrote something about this some years ago, this might do the trick for you, maybe with some adjustments depending
onyour schema. The main idea should help anyway. See:
 
> 
> http://blog.ioguix.net/postgresql/2015/02/05/Partitionning-and-constraints-part-1.html
> 

For the document management schema I need a way to avoid partitioning of
"process-tables", and still be able to FK from it into the document
class forest of inherited tables. Just uniqueness of IDs across that
forest is not enough ... although nice to have, I admit. Good & handy
article. I'll keep a reference to it.

Thenx,

-R


-- 
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: Re: [GENERAL] looking for a globally unique row ID
Next
From: Tomas Vondra
Date:
Subject: Re: [GENERAL] looking for a globally unique row ID