projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
08cd31d
)
Replaced TRUNCATE with DELETE FROM in migration_tools.create_cards
author
Ben Ostrowsky
<ben@esilibrary.com>
Wed, 4 Jan 2012 19:39:39 +0000 (19:39 +0000)
committer
Galen Charlton
<gmc@esilibrary.com>
Mon, 16 Jul 2012 15:33:12 +0000 (11:33 -0400)
sql/base/base.sql
patch
|
blob
|
history
diff --git
a/sql/base/base.sql
b/sql/base/base.sql
index
297c687
..
cb9dab4
100644
(file)
--- a/
sql/base/base.sql
+++ b/
sql/base/base.sql
@@
-1052,7
+1052,7
@@
DECLARE
BEGIN
- EXECUTE ('TRUNCATE ' || c || ';');
+ EXECUTE ('DELETE FROM ' || c || ';');
EXECUTE ('INSERT INTO ' || c || ' (usr, barcode) SELECT id, usrname FROM ' || u || ';');
EXECUTE ('UPDATE ' || u || ' u SET card = c.id FROM ' || c || ' c WHERE c.usr = u.id;');