Best way to create unique primary keys across schemas?

Поиск
Список
Период
Сортировка
От panam
Тема Best way to create unique primary keys across schemas?
Дата
Msg-id 1327277954974-5165043.post@n5.nabble.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Maxim Boguk
Дата:
Сообщение: Question about (probably wrong) index scan cost for conditional indexes
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question about (probably wrong) index scan cost for conditional indexes