hello, i just notice something strange in sqlite. i have a db file which is a copy of another one(not a symlink). when i delete one row from a table in one db file and the same row got delete from the same table in the other db file as well. this happens when i tried dropping a table.
this is debian stable, sqlite 3.2.1 ( yeah, i know this is bit of too old ) % sudo sqlite3 restaurants.db SQLite version 3.2.1 Enter ".help" for instructions sqlite> select * from tmp_suggest; 1|1||75|56||1|1|||||||||||1164260861|1164260861||0|||||| sqlite> % sudo sqlite3 restaurants.db.13 SQLite version 3.2.1 Enter ".help" for instructions sqlite> select * from tmp_suggest; 1|1||75|56||1|1|||||||||||1164260861|1164260861||0|||||| sqlite> delete from tmp_suggest; sqlite> select * from tmp_suggest; sqlite> % sudo sqlite3 restaurants.db SQLite version 3.2.1 Enter ".help" for instructions sqlite> select * from tmp_suggest; sqlite> ##### tried dropping one table. same thing happened, % sudo sqlite3 restaurants.db SQLite version 3.2.1 Enter ".help" for instructions sqlite> drop table tmp_suggest; sqlite> % sudo sqlite3 restaurants.db.13 SQLite version 3.2.1 Enter ".help" for instructions sqlite> .schema tmp_suggest at last, i tried making the second copy of the db file. and the problem went away. has anyone seen this before? James. ____________________________________________________________________________________ Sponsored Link Mortgage rates near 39yr lows. $420k for $1,399/mo. Calculate new payment! www.LowerMyBills.com/lre ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------