I see the same behavior--begin exclusive causes db locked error when same db is attached twice. However, why would you want to attach the same database twice?
SQLite version 3.4.2 Enter ".help" for instructions sqlite> attach 'c.dat' as c1; sqlite> attach 'c.dat' as c2; sqlite> begin exclusive; SQL error: database is locked sqlite> Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Michael Plagge [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 18, 2007 12:58 PM To: [email protected] Subject: Re: [sqlite] Exclusive Transactions and Attached Databases 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? Thanks Michael ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
