Page 1 of 1

Key declarations on virtual relvars ignored

Posted: Thu Nov 26, 2009 7:27 pm
by Adrian_Hudnott
I doubt this so much a bug but more likely a limitation: when I declare a virtual relvar with a non-empty <candidate key def list> it doesn't get enforced. Furthermore there's no note of it existing in the catalog either.

It would be good to add this to the Limitations section of the web site. Personally, I would put alert the user with some kind of warning message raised from the relevant code stub too.

Re: Key declarations on virtual relvars ignored

Posted: Fri Nov 27, 2009 3:11 am
by Dave
Indeed, I'd meant to note this as a limitation long ago but forgot. I've put it on my "to do" list.