Quick Links

Best way to create unique primary keys across schemas?

From:	panam <panam(at)gmx(dot)net>
To:	pgsql-general(at)postgresql(dot)org
Subject:	Best way to create unique primary keys across schemas?
Date:	2012-01-23 00:19:14
Message-ID:	1327277954974-5165043.post@n5.nabble.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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.

Responses

Re: Best way to create unique primary keys across schemas? at 2012-01-23 03:02:11 from Scott Marlowe
Re: Best way to create unique primary keys across schemas? at 2012-01-23 13:30:15 from Chris Angelico
Re: Best way to create unique primary keys across schemas? at 2012-01-24 10:47:59 from Jasen Betts

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2012-01-23 00:28:37	Re: Question about (probably wrong) index scan cost for conditional indexes
Previous Message	Maxim Boguk	2012-01-22 23:58:35	Question about (probably wrong) index scan cost for conditional indexes