Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-09 Thread Dan Kennedy
On 11/10/2018 08:18 AM, Keith Medcalf wrote: On Friday, 9 November, 2018 16:20, J. King wrote: To: SQLite mailing list That could lead to loss of referential integrity when modifying a table in a way not supported by ALTER TABLE, I believe. One usual method is to turn foreign keys off, rena

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-09 Thread Keith Medcalf
On Friday, 9 November, 2018 16:20, J. King wrote: >To: SQLite mailing list >That could lead to loss of referential integrity when modifying a >table in a way not supported by ALTER TABLE, I believe. One usual >method is to turn foreign keys off, rename the old table, create a >new modified table

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-09 Thread J. King
On November 9, 2018 2:50:56 AM EST, Dominique Devienne wrote: >On Fri, Nov 9, 2018 at 8:26 AM Simon Slavin >wrote: > >> On 9 Nov 2018, at 7:11am, Hick Gunter wrote: >> > Foreign keys are ignored by default and need to be explicitly >enabled. I >> would expect this to include everything that rel

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-08 Thread Dominique Devienne
On Fri, Nov 9, 2018 at 8:26 AM Simon Slavin wrote: > On 9 Nov 2018, at 7:11am, Hick Gunter wrote: > > Foreign keys are ignored by default and need to be explicitly enabled. I > would expect this to include everything that relates to foreign keys. > > I've casually discovered that the behavior of

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-08 Thread Simon Slavin
On 9 Nov 2018, at 7:11am, Hick Gunter wrote: > Foreign keys are ignored by default and need to be explicitly enabled. I > would expect this to include everything that relates to foreign keys. > > -Ursprüngliche Nachricht- > > I've casually discovered that the behavior of ALTER TABLE RE

Re: [sqlite] [EXTERNAL] found a glitch in ALTER TABLE RENAME (3.25.x)

2018-11-08 Thread Hick Gunter
Foreign keys are ignored by default and need to be explicitly enabled. I would expect this to include everything that relates to foreign keys. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von a.furi...@lqt.it Gesendet: Donne