github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1597342429_add_deleted_pipelines_table.down.sql (about)

     1  BEGIN;
     2      DROP TABLE IF EXISTS deleted_pipelines;
     3  
     4      CREATE OR REPLACE FUNCTION on_pipeline_delete() RETURNS TRIGGER AS $$
     5      BEGIN
     6          EXECUTE format('DROP TABLE IF EXISTS pipeline_build_events_%s', OLD.id);
     7          RETURN NULL;
     8      END;
     9      $$ LANGUAGE plpgsql;
    10  
    11      DROP TRIGGER IF EXISTS pipeline_build_events_delete_trigger ON pipelines;
    12      CREATE TRIGGER pipeline_build_events_delete_trigger AFTER DELETE on pipelines FOR EACH ROW EXECUTE PROCEDURE on_pipeline_delete();
    13  COMMIT;