Is UUID a data type or a flag like auto_increment? If it is a data type, then I suggest you allow it to be nullable. Otherwise, you cannot implement optional foreign keys based on these columns.
On Wed, Dec 17, 2008 at 8:19 PM, Brian Aker <[email protected]> wrote: > Hi! > > On Dec 17, 2008, at 12:50 AM, Roy Lyseng wrote: > >> IMHO, the data type should not implicitly define any insert/update >> semantics around it, unless it makes no sense to support user-level >> operations (which may be the case for UUID?). > > > Having a column which is UUID that generates one as default is my interest. > Whether that is by pass NULL in or just not listing it in VALUES.... that > is the open question to me. > > Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp > -- Roland Bouman http://rpbouman.blogspot.com/ _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
