diff options
author | Ralph Amissah <ralph@amissah.com> | 2008-02-02 12:33:12 +0000 |
---|---|---|
committer | Ralph Amissah <ralph@amissah.com> | 2008-02-02 12:33:12 +0000 |
commit | a97f505ae72c3dfa7b11bfd637d8e31ef046983a (patch) | |
tree | 5432f37da79e7721f679bf1e0b1c90a3b31fa44a /lib | |
parent | sisu-0.64.2 + md5s (diff) |
for update replace LIKE with '=' ; required by pg8.3 bigint
Diffstat (limited to 'lib')
-rw-r--r-- | lib/sisu/v0/db_remove.rb | 24 |
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") |