f-spot r4486 - in trunk: . src

[sdelcroix svn gnome org]

Author: sdelcroix
Date: Tue Oct 14 08:02:00 2008
New Revision: 4486
URL: http://svn.gnome.org/viewvc/f-spot?rev=4486&view=rev

Log:
2008-10-14  Stephane Delcroix  <sdelcroix novell com>

	* src/Updater.cs: restrict the sql search in MoveTableToTemp to tables

Modified:
   trunk/ChangeLog
   trunk/src/Updater.cs

Modified: trunk/src/Updater.cs
==============================================================================
--- trunk/src/Updater.cs	(original)
+++ trunk/src/Updater.cs	Tue Oct 14 08:02:00 2008
@@ -607,7 +607,7 @@
 			string temp_name = table_name + "_temp";
 			
 			// Get the table definition for the table we are copying
-			string sql = SelectSingleString (String.Format ("SELECT sql FROM sqlite_master WHERE tbl_name = '{0}' ORDER BY type DESC", table_name));
+			string sql = SelectSingleString (String.Format ("SELECT sql FROM sqlite_master WHERE tbl_name = '{0}' AND type = 'table' ORDER BY type DESC", table_name));
 			
 			// Drop temp table if already exists
 			ExecuteNonQuery ("DROP TABLE IF EXISTS " + temp_name);