Re: Globally Unique IDs?

Поиск
Список
Период
Сортировка
От Soma Interesting
Тема Re: Globally Unique IDs?
Дата
Msg-id 5.0.2.1.0.20010330110246.023f30a8@pop.telus.net
обсуждение исходный текст
Ответ на Globally Unique IDs?  ("Rose, Keith" <keithr@aiinet.com>)
Список pgsql-general
At 01:42 PM 3/30/2001 -0500, you wrote:
>I am new to the mailing list, but not new to postgres.  I did search through
>the mail-list archives, and didn't find an answer to this question.  Oracle
>has a concept of a "globally unique ID" which can be gotten from their
>function call SYS_GUID().  Is there any plan to implement this (or something
>analogous) in a future version of Postgres?


I'm far from an expert with Postgresql, but I was just thinking the other
day that you could probably use a single "sequence" in postgres for a
number of tables to make sure id's are unique across multiple tables.

If your not familiar with sequences, see here:
http://www.postgresql.org/devel-corner/docs/user/datatype.html#DATATYPE-SERIAL



В списке pgsql-general по дате отправления:

Предыдущее
От: "Mitch Vincent"
Дата:
Сообщение: Re: Memory Tuning
Следующее
От: "Rose, Keith"
Дата:
Сообщение: RE: Globally Unique IDs?