Re: [sqlite] Attachments and Views - suggested tweak

te> pragma writable_schema = off; sqlite> .tables a_table sqlite> -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jonathan Moules Sent: Tuesday, September 25, 2018 11:55 AM To: SQLite mailing list Subject: [sq

Re: [sqlite] Attachments and Views - suggested tweak

er where name = 'a_view'; sqlite> pragma writable_schema = off; sqlite> .tables a_table sqlite> -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Jonathan Moules Sent: Tuesday, September 25, 2018 11:55 AM To: SQLite mailin

[sqlite] Attachments and Views - suggested tweak

Hi List,     I just caught myself in a little circle and accidentally created a semi-invalid database. I was wondering if it's something SQLite's query parser could self-resolve / alert about. Attach a database as "my_attachment" schema name, and then run: CREATE VIEW my_attachment.a_view AS