Re: Best way to create unique primary keys across schemas? - Mailing list pgsql-general

From Jasen Betts
Subject Re: Best way to create unique primary keys across schemas?
Date
Msg-id jfm28v$5i1$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Best way to create unique primary keys across schemas?  (panam <panam@gmx.net>)
List pgsql-general
On 2012-01-23, panam <panam@gmx.net> wrote:
> Hi,
>
> If I'd like to have primary keys generated ("numeric" style, no UUIDs) that
> are unique across schemas is the best option to allocate a fixed sequence
> range (min,max) to the sequences of all schemas?

given that challenge the easiest solution is to just create one
sequence and hang everything off it.

--
⚂⚃ 100% natural

pgsql-general by date:

Previous
From: Allan Kamau
Date:
Subject: Re: PG migration policy
Next
From: Jasen Betts
Date:
Subject: Re: How to make a non-removable row in a table?