Postgres Pro
Downloads
Home   >   mailing lists

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

From panam
Subject Best way to create unique primary keys across schemas?
Date
Msg-id 1327277954974-5165043.post@n5.nabble.com
Whole thread Raw
Responses Re: Best way to create unique primary keys across schemas?  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Best way to create unique primary keys across schemas?  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
Tree view 
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?

Thanks
panam

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Best-way-to-create-unique-primary-keys-across-schemas-tp5165043p5165043.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Maxim Boguk
Date:
Subject: Question about (probably wrong) index scan cost for conditional indexes
Next
From: Tom Lane
Date:
Subject: Re: Question about (probably wrong) index scan cost for conditional indexes