From d16045afdecb4593ba37419d0e29e46d5419c46c Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Wed, 4 Jan 2012 19:39:39 +0000 Subject: [PATCH] Replaced TRUNCATE with DELETE FROM in migration_tools.create_cards --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 297c687..cb9dab4 100644 --- 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;'); -- 1.7.2.5