Ben Asher, on Friday, August 16, 2019 02:32 PM, wrote... > > Hi folks! We're running (sqlite 3.27.2) into an issue where we make a > schema update (adding a column to a table) on our writer connection, but > then the schema update isn't immediately available on the read-only > connections that we use on other threads, which causes a crash in our > application (app expects the column to exist at that point). I've verified > that the column does indeed get added, and everything works fine after > restarting the application (i.e. all connections loaded fresh pickup the > schema update). > > Is there something we need to do proactively to ensure that schema update > appears immediately from other threads?
Are you using BEGIN and END before and after the schema update? josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users