Re: [sqlite] Error when renaming a table when an invalid view exists in the schema

2019-05-07 Thread Tom Bassel
main.t1 --- Date: Fri, 03 May 2019 13:27:18 -0600 From: "Keith Medcalf" To: "SQLite mailing list" Subject: Re: [sqlite] Error when renaming a table when an invalid view exists in the schema Message-ID: <802bb8bcf08af448bd5d9a4b9bf2f...@mail.dessus.

Re: [sqlite] Error when renaming a table when an invalid view exists in the schema

2019-05-03 Thread Keith Medcalf
Use PRAGMA LEGACY_ALTER_TABLE=ON; The "Legacy alter table" does not require the database to be "valid/consistent" after executing the "alter table" command. The non-legacy (default) mode requires that the database be "transformed" into a "valid/consistent" state in order for the alter table c