Re: looking for a globally unique row ID

From: Rafal Pietrak <rafal(at)ztk-rp(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: looking for a globally unique row ID
Date: 2017-09-16 10:15:46
Message-ID: ea03ec8e-9997-5ffd-681f-2924f2fc646a@ztk-rp.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 on your 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2017-09-16 10:43:27 Re: looking for a globally unique row ID
Previous Message Rafal Pietrak 2017-09-16 09:57:20 Re: looking for a globally unique row ID