Re: UUID as primary key
От | Vance Maverick |
---|---|
Тема | Re: UUID as primary key |
Дата | |
Msg-id | DAA9CBC6D4A7584ABA0B6BEA7EC6FC0B0C494E@hq-exch01.corp.pgp.com обсуждение исходный текст |
Ответ на | Re: UUID as primary key (Roman Neuhauser <neuhauser@sigpipe.cz>) |
Ответы |
Re: UUID as primary key
|
Список | pgsql-general |
Can you give a link to the PostgreSQL binding? I haven't been able to find it there. All I see is C, Perl and PHP bindings for the generation of UUIDs, and nothing about storage. (For my application, as it happens, I don't need to generate UUIDs in the database, but I recognize that would be useful.) Vance > > Ralf Engelschall's OSSP uuid looks very good. Written in C with > interfaces into PostgreSQL, PHP and C++ (classes wrapping the C > structures and functions). > > http://www.ossp.org/pkg/lib/uuid/ > > You should be able to e. g. > > CREATE TABLE t (id UUID DEFAULT 'uuid(4)' PRIMARY KEY); > > -- > How many Vietnam vets does it take to screw in a light bulb? > You don't know, man. You don't KNOW. > Cause you weren't THERE. http://bash.org/?255991 >
В списке pgsql-general по дате отправления: