Attached databases & locking

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Attached databases & locking

Tim McDaniel
Question...

Two database files, say A & B.
Open A.
Attach B.
Write to a table in A.
Write to a table in B.

During the writes, is the file not being written to locked?

Thanks,
Tim
Reply | Threaded
Open this post in threaded view
|

Re: Attached databases & locking

D. Richard Hipp
On Thu, 2005-06-23 at 14:50 -0700, Tim McDaniel wrote:

> Question...
>
> Two database files, say A & B.
> Open A.
> Attach B.
> Write to a table in A.
> Write to a table in B.
>
> During the writes, is the file not being written to locked?
>

No locks are taken on unused databases.
--
D. Richard Hipp <[hidden email]>