Re: [sqlite] Circular References [Was: Re: [RFE bug] Improve error reporting for foreign keys]

2014-10-27 Thread Nico Williams
On Mon, Oct 27, 2014 at 4:19 AM, Simon Slavin wrote: > A foreign key which points to the same table had not occurred to me, outside > of abstract mathematical exercises. I think you've come up with an > acceptable example of why I felt reluctant to condemn the practise.

Re: [sqlite] Circular References [Was: Re: [RFE bug] Improve error reporting for foreign keys]

2014-10-27 Thread Simon Slavin
On 27 Oct 2014, at 9:11am, Tristan Van Berkom wrote: > This seems to me to be an elegant solution, but I'd be curious to > know if it would be considered badly designed for some reason, and > would be interested to know what kind of alternatives people would > propose.

[sqlite] Circular References [Was: Re: [RFE bug] Improve error reporting for foreign keys]

2014-10-27 Thread Tristan Van Berkom
[Changing subject line as this strays away from the original topic] On Mon, 2014-10-27 at 08:22 +, Simon Slavin wrote: > On 27 Oct 2014, at 8:17am, Clemens Ladisch wrote: > > > Tristan Van Berkom wrote: > >> locateFKeyIndex() function issuing the not-so-informative > >>