X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2F16_delete_usrs_stage_1.sql;h=78c3956d7b82f62c07bdb03e5def8a3d4066380b;hp=32eaf302c3a04be06a5ad4008e60a0b124ef767d;hb=59a641b21b06f721bb092b8a889a03638e0ad295;hpb=42eb9d7f3a97f84687cffb60cf0cd5d0dafde529 diff --git a/remove_ou_data/16_delete_usrs_stage_1.sql b/remove_ou_data/16_delete_usrs_stage_1.sql index 32eaf30..78c3956 100644 --- a/remove_ou_data/16_delete_usrs_stage_1.sql +++ b/remove_ou_data/16_delete_usrs_stage_1.sql @@ -19,6 +19,10 @@ \set ECHO all \timing +-- creates an output file for serially deleting users, +-- makes it easier than finding each problem stopping a batch +-- creates a stage 2 inbetween 1 and 3 + \t \psql format unaligned \o 16_delete_usrs_stage_2.sql @@ -32,4 +36,7 @@ FROM actor.usr WHERE home_ou IN ( SELECT 'ALTER TABLE actor.usr ENABLE RULE protect_user_delete;'; \o +\pset format aligned +\t +