for update replace LIKE with '=' ; required by pg8.3 bigint

1 files changed, 12 insertions, 12 deletions

diff --git a/lib/sisu/v0/db_remove.rb b/lib/sisu/v0/db_remove.rb
index 867f5d22..f84e3e05 100644
--- a/lib/sisu/v0/db_remove.rb
+++ b/lib/sisu/v0/db_remove.rb
@@ -72,19 +72,19 @@ module SiSU_DB_remove
         del_id=del.join
         #@conn.execute("BEGIN")
         @conn.execute(%{
-          DELETE FROM endnotes WHERE metadata_tid LIKE '#{del_id}';
-          DELETE FROM endnotes_asterisk WHERE metadata_tid LIKE '#{del_id}';
-          DELETE FROM endnotes_plus WHERE metadata_tid LIKE '#{del_id}';
-          DELETE FROM documents WHERE metadata_tid LIKE '#{del_id}';
-          DELETE FROM urls WHERE metadata_tid LIKE '#{del_id}';
-          DELETE FROM metadata WHERE tid LIKE '#{del_id}';
+          DELETE FROM endnotes WHERE metadata_tid = '#{del_id}';
+          DELETE FROM endnotes_asterisk WHERE metadata_tid = '#{del_id}';
+          DELETE FROM endnotes_plus WHERE metadata_tid = '#{del_id}';
+          DELETE FROM documents WHERE metadata_tid = '#{del_id}';
+          DELETE FROM urls WHERE metadata_tid = '#{del_id}';
+          DELETE FROM metadata WHERE tid = '#{del_id}';
           /*
-          DELETE FROM documents WHERE documents.metadata_tid LIKE '#{del_id}';
-          DELETE FROM endnotes WHERE endnotes.metadata_tid LIKE '#{del_id}';
-          DELETE FROM endnotes_asterisk WHERE endnotes_asterisk.metadata_tid LIKE '#{del_id}';
-          DELETE FROM endnotes_plus WHERE endnotes_plus.metadata_tid LIKE '#{del_id}';
-          DELETE FROM urls WHERE urls.metadata_tid LIKE '#{del_id}';
-          DELETE FROM metadata WHERE metadata.tid LIKE '#{del_id}';
+          DELETE FROM documents WHERE documents.metadata_tid = '#{del_id}';
+          DELETE FROM endnotes WHERE endnotes.metadata_tid = '#{del_id}';
+          DELETE FROM endnotes_asterisk WHERE endnotes_asterisk.metadata_tid = '#{del_id}';
+          DELETE FROM endnotes_plus WHERE endnotes_plus.metadata_tid = '#{del_id}';
+          DELETE FROM urls WHERE urls.metadata_tid = '#{del_id}';
+          DELETE FROM metadata WHERE metadata.tid = '#{del_id}';
           */
         })
         #@conn.execute("COMMIT")