[sqlite] PRAGMA foreign_key_list

Hi, I am curious - how hard will it be to add the constraint name to the result of this view? Thank you. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA foreign_key_list(table-name);

> Le 30 mars 2017 à 11:45, Simon Slavin a écrit : > >> But: >> >> PRAGMA foreign_key_list(table-name); > > Likewise. I agree that the documentation should have "schema." somewhere for > this one. After some tests, it looks like: PRAGMA

Re: [sqlite] PRAGMA foreign_key_list(table-name);

> On 30 Mar 2017, at 9:59am, Olivier Mascia wrote: > > PRAGMA schema.foreign_key_check(table-name); > > (with 'schema.' being optional of course) Had I not read the documentation I’d have tried PRAGMA foreign_key_check(schema.table-name); and expected it to work. >

[sqlite] PRAGMA foreign_key_list(table-name);

Regarding https://www.sqlite.org/pragma.html#pragma_foreign_key_list: I see: PRAGMA schema.foreign_key_check(table-name); (with 'schema.' being optional of course) But: PRAGMA foreign_key_list(table-name); (no schema option apparently) Am I missing something? Or is the

[sqlite] PRAGMA foreign_key_list

The documentation for the above command on the SQLite web site is silent about the output of the above PRAGMA. I can guess at some of it but does anyone have a full description of it? Thanks, Pete lcSQL Software Home of lcStackBrowser

Re: [sqlite] pragma foreign_key_list

On Dec 11, 2010, at 2:29 AM, Simon Slavin wrote: > Then all the other PRAGMAs that do this could be removed While a consistent, comprehensive API would be nice, the problem with pragmas is that, even though they return what looks like a result set, they are neither selectable, nor queryable

Re: [sqlite] pragma foreign_key_list

On 10 Dec 2010, at 10:51pm, BareFeetWare wrote: > Could you please consider taking it further, providing foreign keys via a > select query instead of a pragma? SQLite currently provides limited > introspection, some via select * from SQLite_Master and some via pragmas. Of > the two, select is

Re: [sqlite] pragma foreign_key_list

On 10/12/2010, at 10:17 PM, Richard Hipp wrote: > Version 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh) Great news, thank you. Why the sigh? Do you not see the value in us having introspection into schemas? Could you please consider taking it further, providing foreign

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On [Fri, 10.12.2010 06:17], Richard Hipp wrote: > On Fri, Dec 10, 2010 at 4:54 AM, Jan wrote: > > > > > > > Am 08.12.2010 20:44, schrieb Richard Hipp: > > > Now that foreign key constraints are enforced natively, why would you > > want > > > to have a list of them? Why should

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On 12/10/10 10:36 AM, "Petite Abeille" wrote: On Dec 10, 2010, at 12:17 PM, Richard Hipp wrote: > I relented on this two days ago. See > http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version > 3.7.5 will list PRAGMA foreign_key_list as fully

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Dec 10, 2010, at 12:17 PM, Richard Hipp wrote: > I relented on this two days ago. See > http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version > 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh) Much excellent. Thanks :)

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Am 10.12.2010 12:17, schrieb Richard Hipp: > I relented on this two days ago. See > http://www.sqlite.org/docsrc/info/d399230aae for the check-in. Version > 3.7.5 will list PRAGMA foreign_key_list as fully supported. (sigh) That is great! Thanks a lot. Guess you saved many people from a

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Fri, Dec 10, 2010 at 4:54 AM, Jan wrote: > > > Am 08.12.2010 20:44, schrieb Richard Hipp: > > Now that foreign key constraints are enforced natively, why would you > want > > to have a list of them? Why should the foreign_key_list pragma continue > to > > consume code space

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Am 08.12.2010 20:44, schrieb Richard Hipp: > Now that foreign key constraints are enforced natively, why would you want > to have a list of them? Why should the foreign_key_list pragma continue to > consume code space and developer maintenance time? Was this only a rhetorical question? Or is

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Richard, On 12/8/10 11:44 AM, "Richard Hipp" wrote: On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille wrote: > Hello, > > The pragma foreign_key_list appears to be deprecated in 3.7.4: > > http://www.sqlite.org/pragma.html#pragma_foreign_key_list > >

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

>> The pragma foreign_key_list appears to be deprecated in 3.7.4: Oh no. That is bad news. Please restore this feature. > Now that foreign key constraints are enforced natively, why would you want to > have a list of them? Why should the foreign_key_list pragma continue to > consume code

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Foreign key information is highly useful in many different ORM systems in many different languages. My personal example, the "An ORM for any SQLite database in one line of code" ORLite module in Perl. http://search.cpan.org/perldoc?ORLite It is expected to generate entire class trees for any

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Wed, Dec 8, 2010 at 2:44 PM, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille > wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >>

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On 8 Dec 2010, at 8:03pm, Bogdan Ureche wrote: > Now that foreign key constraints are enforced natively, why would you want > >> to have a list of them? Why should the foreign_key_list pragma continue to >> consume code space and developer maintenance time? > > It would make life easier for

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On 8 December 2010 20:44, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille > wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >> http://www.sqlite.org/pragma.html#pragma_foreign_key_list >>

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

That is very bad news ... My application uses this information e.g. to automatically populate comboboxes (FKs) etc. Am 08.12.2010 20:35, schrieb Petite Abeille: > Hello, > > The pragma foreign_key_list appears to be deprecated in 3.7.4: > >

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Dec 8, 2010, at 8:44 PM, Richard Hipp wrote: > Now that foreign key constraints are enforced natively, why would you want > to have a list of them? To know what they are. In the same way as there are pragma that list database, table, column, index, etc... To paraphrase: "Now that tables

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

Now that foreign key constraints are enforced natively, why would you want > to have a list of them? Why should the foreign_key_list pragma continue to > consume code space and developer maintenance time? > > > It would make life easier for developers of administration tools for SQLite, for

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Dec 8, 2010, at 2:44 PM, Richard Hipp wrote: > On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille >wrote: > >> Hello, >> >> The pragma foreign_key_list appears to be deprecated in 3.7.4: >> >> http://www.sqlite.org/pragma.html#pragma_foreign_key_list >> >> Any reason

Re: [sqlite] pragma foreign_key_list deprecated in 3.7.4?

On Wed, Dec 8, 2010 at 2:35 PM, Petite Abeille wrote: > Hello, > > The pragma foreign_key_list appears to be deprecated in 3.7.4: > > http://www.sqlite.org/pragma.html#pragma_foreign_key_list > > Any reason for such deprecation? > Now that foreign key constraints are

[sqlite] pragma foreign_key_list deprecated in 3.7.4?

Hello, The pragma foreign_key_list appears to be deprecated in 3.7.4: http://www.sqlite.org/pragma.html#pragma_foreign_key_list Any reason for such deprecation? What's the alternative to that pragma to achieve the same effect? Thanks in advance.