Re: [sqlite] Constraint name?

2010-11-12 Thread Petite Abeille
On Nov 12, 2010, at 8:18 PM, Roger Binns wrote: > Your definition of "proper" appears to be some ISO standard :-) Nah, not specially fond of that ISO standard, more for illustration purpose really. > SQLite's approach is certainly acceptable to most (evidence: if not > there would be a lot of

Re: [sqlite] Constraint name?

2010-11-12 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/12/2010 10:04 AM, Petite Abeille wrote: > Thanks for that. Since 2006? High priority indeed :) That the ticket averages a small number of comments per year is an indication that perhaps its priority is about right. Many other ticket tracking sy

Re: [sqlite] Constraint name?

2010-11-12 Thread Petite Abeille
On Nov 12, 2010, at 7:20 AM, Roger Binns wrote: >> A ticket that has been open on this topic since January 2006. > > Oops, forgot to paste: > > http://www.sqlite.org/src/tktview?name=23b2128201 Thanks for that. Since 2006? High priority indeed :) That said, maybe SQLite has reached a point w

Re: [sqlite] Constraint name?

2010-11-11 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/11/2010 09:40 PM, Roger Binns wrote: > A ticket that has been open on this topic since January 2006. Oops, forgot to paste: http://www.sqlite.org/src/tktview?name=23b2128201 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Lin

Re: [sqlite] Constraint name?

2010-11-11 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/11/2010 11:12 AM, Petite Abeille wrote: > Is there a way, short of parsing the original DDL, to retrieve a constraint > name? [..] > How does one retrieve the unique constraint name, "foo_uk"? A ticket that has been open on this topic since Jan

[sqlite] Constraint name?

2010-11-11 Thread Petite Abeille
Hello, Is there a way, short of parsing the original DDL, to retrieve a constraint name? For example, given: create table foo ( bar text, constraint foo_uk unique( bar ) ) How does one retrieve the unique constraint name, "foo_uk"? Thanks. Cheers, PA. __