search

dream120 / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

candidate_keys lists nullable unique indexes #6

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
the current implementation of candidate_keys view lists nullable unique 
indexes. These are not true candidate keys, because the occurrence of null 
values could make it impossible to uniquely identify a row.

Original issue reported on code.google.com by roland.bouman on 6 Sep 2011 at 10:15

GoogleCodeExporter commented 9 years ago 
Indeed so. I will fix it.

Original comment by shlomi.n...@gmail.com on 6 Sep 2011 at 10:24

GoogleCodeExporter commented 9 years ago 
This is fixed in revision 71 (not yet released)
I have made some changes and additions to views, plus a new view. Please read 
revision comment.

In short: I do suggest unique keys which has nullable keys, but notifies the 
user about that.

Original comment by shlomi.n...@gmail.com on 7 Sep 2011 at 5:50