diff options
| author | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-18 12:38:16 +0300 |
|---|---|---|
| committer | Roman Chvanikov <chvanikoff@pm.me> | 2020-05-18 12:38:16 +0300 |
| commit | 1be6b3056e97654612f377eaf3c8d80de6d8d77f (patch) | |
| tree | 8f42e73758d11b7891de3e781d0164a9d95c9ea9 | |
| parent | 01bd6a1e54c8734e8965f153a9406cecc07950f3 (diff) | |
| download | pleroma-1be6b3056e97654612f377eaf3c8d80de6d8d77f.tar.gz pleroma-1be6b3056e97654612f377eaf3c8d80de6d8d77f.zip | |
Use indexed split_part/3 to get a hostname rather than ts_ functions
| -rw-r--r-- | priv/repo/migrations/20200508092434_update_counter_cache_table.exs | 7 |
1 files changed, 1 insertions, 6 deletions
diff --git a/priv/repo/migrations/20200508092434_update_counter_cache_table.exs b/priv/repo/migrations/20200508092434_update_counter_cache_table.exs index 3d9bfc877..738344868 100644 --- a/priv/repo/migrations/20200508092434_update_counter_cache_table.exs +++ b/priv/repo/migrations/20200508092434_update_counter_cache_table.exs @@ -25,22 +25,17 @@ defmodule Pleroma.Repo.Migrations.UpdateCounterCacheTable do RETURNS TRIGGER AS $$ DECLARE - token_id smallint; hostname character varying(255); visibility_new character varying(64); visibility_old character varying(64); actor character varying(255); BEGIN - SELECT "tokid" INTO "token_id" FROM ts_token_type('default') WHERE "alias" = 'host'; IF TG_OP = 'DELETE' THEN actor := OLD.actor; ELSE actor := NEW.actor; END IF; - SELECT "token" INTO "hostname" FROM ts_parse('default', actor) WHERE "tokid" = token_id; - IF hostname IS NULL THEN - hostname := split_part(actor, '/', 3); - END IF; + hostname := split_part(actor, '/', 3); IF TG_OP = 'INSERT' THEN visibility_new := activity_visibility(NEW.actor, NEW.recipients, NEW.data); IF NEW.data->>'type' = 'Create' |