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 afb35fa8-e6ca-5093-3d78-3ca18acedd2f@ztk-rp.eu
Whole thread Raw
In response to Re: [GENERAL] looking for a globally unique row ID  ("Jehan-Guillaume (ioguix) de Rorthais" <ioguix@free.fr>)
List pgsql-general

W dniu 18.09.2017 o 17:26, Jehan-Guillaume (ioguix) de Rorthais pisze:
> On Sat, 16 Sep 2017 12:15:46 +0200
> Rafal Pietrak <rafal@ztk-rp.eu> wrote:
> 
>> W dniu 16.09.2017 o 09:33, Jehan-Guillaume de Rorthais pisze:

[-------------]
> 
> About FK, just look at pgsql trigger code around real FK and adjust to your
> need by creating custom FK trigger either in plpgsql or C. IIRC, there's a
> contrib module doing FK as well, look at "contrib/spi/refint.c".
> 
> 

OK. I'll look into it, too. But the "discovery" of
pg_advisory_xact_lock() itself is a revelation for me :)

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: Tom Lane
Date:
Subject: Re: [GENERAL] reload postgresql with invalid pg_hba.conf
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] reload postgresql with invalid pg_hba.conf