From 2cebd797014561ebc0bfee07ee8b5d83820adb66 Mon Sep 17 00:00:00 2001 From: Chocobozzz Date: Thu, 26 Jul 2018 10:45:10 +0200 Subject: Fix last commit --- server/initializers/database.ts | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'server/initializers/database.ts') diff --git a/server/initializers/database.ts b/server/initializers/database.ts index d95e34bce..1a9ce5a61 100644 --- a/server/initializers/database.ts +++ b/server/initializers/database.ts @@ -125,10 +125,11 @@ async function checkPostgresExtensions () { } async function createFunctions () { - const query = `CREATE OR REPLACE FUNCTION immutable_unaccent(varchar) - RETURNS text AS $$ - SELECT unaccent($1) - $$ LANGUAGE sql IMMUTABLE;` + const query = `CREATE OR REPLACE FUNCTION immutable_unaccent(text) + RETURNS text AS +$func$ +SELECT public.unaccent('public.unaccent', $1::text) +$func$ LANGUAGE sql IMMUTABLE;` return sequelizeTypescript.query(query, { raw: true }) } -- cgit v1.2.3