"Anders Holmberg" <[EMAIL PROTECTED]> wrote: > Hi > > I am using sqlite (version 3.3.7) on Windows and I am loading one database > (stored in a file) into another database (:memory:) using the attach / > detatch scheme described on the sqlite site. > > My problem is that sqlite keeps hanging on to the first database even after > I have made a detach; which makes it impossible for me (or my program) to > delete the original file. > > Is there something more I need to do make sqlite "forget" about the file? >
Unable to reproduce. "lsof" shows that sqlite3 closes the file handle just fine when you detach on linux. Perhaps your detach is failing. What does "PRAGMA database_list" show after the detach? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------