Am 18.09.2007 um 19:26 schrieb [EMAIL PROTECTED]:

Michael Plagge <[EMAIL PROTECTED]> wrote:

Just for interest: Am I the only one being faced with the quoted
situation and did I not understand the documentation, or is there
some misbehaviour in sqlite's handling of multiply attached database
files?

You are probably the only person who has ever tried to do this.
If you think it is wrong, you can write a trouble ticket and we
will look into fixing it.  However, understand that after looking
at what will be involved in fixing the problem and weighing that
against the benefits of fixing it, we might choose to document
the current behavior as "intentional"  ;-)

I just filed a trouble ticket, at least for completion because I think this could be rated a bug as it does not fully conform to the documentation. If there should be more important issues (...), it would be great to find an appropriate note in the docs to clarify that exclusive transactions are not possible with database files that are attached more than once.

Regards
Michael


Am 15.09.2007 um 19:43 schrieb Michael Plagge:

Dear group,

regarding the docs, it is possible to attach the same database file
multiple times.

After doing so, I wanted to begin an exclusive transaction.
Unfortunately, this fails ("database is locked") and surprises me
as I did not find any notice on this particular situation and
possible side-effects neither in the attach nor in the transaction/
locking documentation.

Is this an intended behaviour of SQLite? Or just a side-effect in
preventing possible dead-locks? The problem occurred with version
3.3.7.

Regards
Michael


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to