[R-sig-DB] RSQLite: ATTACH statement not executed when the db connection is holding a resultSet

[Herve Pages]

Hi Gabor,

Gabor Grothendieck wrote:
> I don't think you have established db1.sqlite as an external sqlite
> database yet -- its still only known to the db1 connection.  Try
> disconnecting from db1 before attaching it in the db2 connection to
> flush it out.

No, disconnecting from db1 doesn't change anything. When someone in my
group found this problem, he was working with real dbs i.e. dbs that have
been on disk for a long time and opened/closed many times. Using a freshly
created db1.sqlite in my example is only for the purpose of providing
reproducible code.

Anyway if ATTACH fails for the reason you suggest or for whatever reason,
then an error should be raised.

Thanks,
H.


> 
> You can likely re-connect to db1 again right after disconnecting db1
> even before attaching it in db2 if you wish -- that would be optional.
>