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.
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
2 matches
Mail list logo