Re: Informix 7.3 on Linux -25580 Error

From: Thomas Parsli <thomas.parsli@startsiden.no> > >Paul Brown <paul.NOSPAM.brown@informix.com> writes: > > > Thomas Parsli wrote: > > > > > The new datatypes and the possibility to extent those are great, but > > > we still can't create indexes on those -and forget about foreign >keys... > > > > Woah nellie! > >Nellie? Nellie! I've been called worse! > > You can't index ROW TYPES (yet). But you sure as shoot can create >indices on > > OPAQUE and DISTINCT types (that's how the R-Tree stuff for spatial >works), defined > > primary keys using them, and also referential integrity constraints. > >Yes I know, I was talking about the _new_ datatypes (in 9.2) not opaque and >distinct... >(If you don't understand my english we can turn to norwegian instead) I don't understand your English either -- what new data types in 9.2 are you talking about? >I find the datatypes cool -and the lack of indexes (on them) uncool;) Which data types? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com