Only create ltree postgres extension in migration if doesn't already exist (#3092)

[lemmy.git] / migrations / 2022-07-07-182650_comment_ltrees / up.sql

diff --git a/migrations/2022-07-07-182650_comment_ltrees/up.sql b/migrations/2022-07-07-182650_comment_ltrees/up.sql
index fde9e1b31e5c0e522de2b1bd4342dd64211f75cc..4d2598dda77fb5888e5fa51f5682c83762e9f876 100644 (file)
--- a/migrations/2022-07-07-182650_comment_ltrees/up.sql
+++ b/migrations/2022-07-07-182650_comment_ltrees/up.sql
@@ -30,7 +30,7 @@ drop view comment_alias_1;
 
 alter table comment drop column read;
 
-create extension ltree;
+create extension if not exists ltree;
 
 alter table comment add column path ltree not null default '0';
 alter table comment_aggregates add column child_count integer not null default 0;
@@ -60,7 +60,7 @@ ORDER BY
        breadcrumb;
 
 -- Remove indexes and foreign key constraints, and disable triggers for faster updates
-alter table comment disable trigger all;
+alter table comment disable trigger user;
 
 alter table comment drop constraint if exists comment_creator_id_fkey;
 alter table comment drop constraint if exists comment_parent_id_fkey;
@@ -115,4 +115,4 @@ create index idx_path_gist on comment using gist (path);
 -- Drop the parent_id column
 alter table comment drop column parent_id cascade;
 
-alter table comment enable trigger all;
+alter table comment enable trigger user;