| Subject | RE: [firebird-support] UUDIs/GUIDs and problem with uuidlib |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-07-18T13:49:42Z |
At 11:17 PM 18/07/2006, you wrote:
of UUID/GUID as a unique key as hard as Daniel does. If you're
generating it from a trigger, you just need to include a fallback
that grabs another one if a duplication is encountered.
./heLen
> >Not guaranteed to be unique. But I wouldn't stress the "uselessness"
> > -----Original Message-----
> > From: firebird-support@yahoogroups.com
>[mailto:firebird-support@yahoogroups.com] On Behalf Of Daniel Albuschat
> > Sent: Tuesday, July 18, 2006 8:02 AM
> > To: firebird-support@yahoogroups.com
> > Subject: Re: [firebird-support] UUDIs/GUIDs and problem with uuidlib
> >
> >
> > 2006/7/18, lutterot <lutteroth@...>:
> > > Hello!
> > >
> > > I need to use UUDIs/GUIDs as primary keys in my DB and was trying to
> > > generate/convert them with the uuidlib UDF library available on
> > > IBPhoenix.
> >
> > Don't do this. It's fine to have a UUID as a separate, unique field
> > but having it
> > as a primary key is not good, not at all.
> >
>
>Because...?
of UUID/GUID as a unique key as hard as Daniel does. If you're
generating it from a trigger, you just need to include a fallback
that grabs another one if a duplication is encountered.
./heLen