hema is changed, why can’t it tell to itself ?
原始邮件
发件人:sanhua.zhsanhua...@foxmail.com
收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org
发送时间:2016年10月21日(周五) 14:48
主题:Re: [sqlite] Drop Existing Table Results in 'no such table'
You are changing the details saved on disk but not
To: SQLite mailing list
Subject: Re: [sqlite] Drop Existing Table Results in 'no such table'
You are changing the details saved on disk but not the copy in memory.
Since reopen a new connection is a ugly way, is there any other way to update
the memory ?
I know that sqlite3InitCallback may update it, b
> On Oct 20, 2016, at 11:40 PM, Clemens Ladisch wrote:
>
> sanhua.zh wrote:
>> I am trying to rename a table by editing the sqlite_master directly.
>
> Don't do this.
Patient: “Doctor, my arm hurts when I do this!”
Doctor: “Then don’t do that.”
—Jens
:sanhua.zhsanhua...@foxmail.com
收件人:SQLite mailing listsqlite-us...@mailinglists.sqlite.org
发送时间:2016年10月21日(周五) 14:48
主题:Re: [sqlite] Drop Existing Table Results in 'no such table'
You are changing the details saved on disk but not the copy in memory. Since
reopen a new connection is a ugly way
On 21 October 2016 at 14:49, sanhua.zh wrote:
> Don't do this.
> I don’t think so. It is written on the sqlite.com. So it should be a
> tricky way but not a wrong way.
>
The docs say, regarding the procedure you followed:
> The following simpler procedure is appropriate
] Drop Existing Table Results in 'no such table'
sanhua.zh wrote: I am trying to rename a table by editing the sqlite_master
directly. Don't do this. But I find that the ‘no such table’ error occurs
while I try to drop the renamed table. Only I close the connection or start a
new connection
:SQLite mailing listsqlite-us...@mailinglists.sqlite.org
发送时间:2016年10月21日(周五) 14:39
主题:Re: [sqlite] Drop Existing Table Results in 'no such table'
On 21 Oct 2016, at 4:42am, sanhua.zh sanhua...@foxmail.com wrote: I am trying
to rename a table by editing the sqlite_master directly. I do know
sanhua.zh wrote:
> I am trying to rename a table by editing the sqlite_master directly.
Don't do this.
> But I find that the ‘no such table’ error occurs while I try to drop
> the renamed table. Only I close the connection or start a new
> connection, the renamed table can be dropped.
On 21 Oct 2016, at 4:42am, sanhua.zh wrote:
> I am trying to rename a table by editing the sqlite_master directly. I do
> know there are a ‘ALTER TABLE … RENAME TO …’ syntax to do that. I just want
> to try it in this way.
> But I find that the ‘no such table’ error
I am trying to rename a table by editing the sqlite_master directly. I do know
there are a ‘ALTER TABLE … RENAME TO …’ syntax to do that. I just want to try
it in this way.
But I find that the ‘no such table’ error occurs while I try to drop the
renamed table.
Only I close the connection or
10 matches
Mail list logo