Re: Globally Unique IDs?
От | Mitch Vincent |
---|---|
Тема | Re: Globally Unique IDs? |
Дата | |
Msg-id | 00f001c0b949$c60fcf90$0b51000a@epox450 обсуждение исходный текст |
Ответ на | Globally Unique IDs? ("Rose, Keith" <keithr@aiinet.com>) |
Список | pgsql-general |
You can get the same result I suppose if you just use the same sequence across all your tables.. Is Oracle doing anything more than that? You could even make a quick function to get the next value from a sequence and call it SYS_GUID() -- just an idea :-) Good luck! -Mitch Software development : You can have it cheap, fast or working. Choose two. ----- Original Message ----- From: "Rose, Keith" <keithr@aiinet.com> To: "'PostgreSQL General'" <pgsql-general@postgresql.org> Sent: Friday, March 30, 2001 1:42 PM Subject: Globally Unique IDs? > 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? > > -- > Keith Rose (ext. 2144) > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster >
В списке pgsql-general по дате отправления: