To be clear, my question about all bets being off sounded more rhetorical
in my head than it came out. I'm perfectly content with the outcome, just
wanted to share an example of something I accidently learned the hard way
when messing with schemas. And thanks to you all I know more about why it

On Oct 17, 2016 5:21 PM, "Kees Nuyt" <> wrote:

> On Mon, 17 Oct 2016 15:40:44 -0500, Ben Newberg
> <> wrote:
> > But I've seen some strange things when messing with pragma
> writable_schema.
> > It appears all bets are off?
> Yes. that's why there's a warning:
> "Warning: misuse of this pragma can easily result in
>  a corrupt database file."
> When changing anything in the sqlite_master table you are
> circumventing all mechanisms SQLite has to keep the database
> consistent.
> What you did in your example is creating a table description in
> sqlite_master that doesn't match the physical table in the
> database, so yes, all bets are off.
> --
> Regards,
> Kees Nuyt
> _______________________________________________
> sqlite-users mailing list
sqlite-users mailing list

Reply via email to