NotificationsYou must be signed in to change notification settings
Fork121
Star170

Commit7e0c205

authored

bug: add search path to postgres functions (#449)

1 parente47cf93 commit7e0c205Copy full SHA for 7e0c205

File tree

1 file changed

+12

-2

lines changed

lib/migration_generator
- ash_functions.ex

1 file changed

+12

-2

lines changed

`‎lib/migration_generator/ash_functions.ex‎`

Lines changed: 12 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,13 +10,15 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`10`	`10`	`CREATE OR REPLACE FUNCTION ash_elixir_or(left BOOLEAN, in right ANYCOMPATIBLE, out f1 ANYCOMPATIBLE)`
`11`	`11`	`AS $$ SELECT COALESCE(NULLIF($1, FALSE), $2) $$`
`12`	`12`	`LANGUAGE SQL`
	`13`	`+ SET search_path = ''`
`13`	`14`	`IMMUTABLE;`
`14`	`15`	`\"\"\")`
`15`	`16`
`16`	`17`	`execute(\"\"\"`
`17`	`18`	`CREATE OR REPLACE FUNCTION ash_elixir_or(left ANYCOMPATIBLE, in right ANYCOMPATIBLE, out f1 ANYCOMPATIBLE)`
`18`	`19`	`AS $$ SELECT COALESCE($1, $2) $$`
`19`	`20`	`LANGUAGE SQL`
	`21`	`+ SET search_path = ''`
`20`	`22`	`IMMUTABLE;`
`21`	`23`	`\"\"\")`
`22`	`24`
`@@ -27,6 +29,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`27`	`29`	`ELSE $1`
`28`	`30`	`END $$`
`29`	`31`	`LANGUAGE SQL`
	`32`	`+ SET search_path = ''`
`30`	`33`	`IMMUTABLE;`
`31`	`34`	`\"\"\")`
`32`	`35`
`@@ -37,6 +40,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`37`	`40`	`ELSE $1`
`38`	`41`	`END $$`
`39`	`42`	`LANGUAGE SQL`
	`43`	`+ SET search_path = ''`
`40`	`44`	`IMMUTABLE;`
`41`	`45`	`\"\"\")`
`42`	`46`
`@@ -62,6 +66,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`62`	`66`	`END IF;`
`63`	`67`	`END; $$`
`64`	`68`	`LANGUAGE plpgsql`
	`69`	`+ SET search_path = ''`
`65`	`70`	`IMMUTABLE;`
`66`	`71`	`\"\"\")`
`67`	`72`
`@@ -115,6 +120,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`115`	`120`	`END IF;`
`116`	`121`	`END; $$`
`117`	`122`	`LANGUAGE plpgsql`
	`123`	`+ SET search_path = ''`
`118`	`124`	`IMMUTABLE;`
`119`	`125`	`\"\"\")`
`120`	`126`	`"""`
`@@ -177,7 +183,8 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`177`	`183`	`RAISE EXCEPTION '#{prefix}%', json_data::text;`
`178`	`184`	`RETURN NULL;`
`179`	`185`	`END;`
`180`		`- $$ LANGUAGE plpgsql;`
	`186`	`+ $$ LANGUAGE plpgsql`
	`187`	`+ SET search_path = '';`
`181`	`188`	`\"\"\")`
`182`	`189`
`183`	`190`	`execute(\"\"\"`
`@@ -189,7 +196,8 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`189`	`196`	`RAISE EXCEPTION '#{prefix}%', json_data::text;`
`190`	`197`	`RETURN NULL;`
`191`	`198`	`END;`
`192`		`- $$ LANGUAGE plpgsql;`
	`199`	`+ $$ LANGUAGE plpgsql`
	`200`	`+ SET search_path = '';`
`193`	`201`	`\"\"\")`
`194`	`202`	`"""`
`195`	`203`	`end`
`@@ -220,6 +228,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`220`	`228`	`END`
`221`	`229`	`$$`
`222`	`230`	`LANGUAGE PLPGSQL`
	`231`	`+ SET search_path = ''`
`223`	`232`	`VOLATILE;`
`224`	`233`	`\"\"\")`
`225`	`234`
`@@ -230,6 +239,7 @@ defmodule AshPostgres.MigrationGenerator.AshFunctions do`
`230`	`239`	`SELECT to_timestamp(('x0000' \|\| substr(_uuid::TEXT, 1, 8) \|\| substr(_uuid::TEXT, 10, 4))::BIT(64)::BIGINT::NUMERIC / 1000);`
`231`	`240`	`$$`
`232`	`241`	`LANGUAGE SQL`
	`242`	`+ SET search_path = ''`
`233`	`243`	`IMMUTABLE PARALLEL SAFE STRICT;`
`234`	`244`	`\"\"\")`
`235`	`245`	`"""`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Uh oh!

Commit7e0c205

File tree

1 file changed

1 file changed

`‎lib/migration_generator/ash_functions.ex‎`

0 commit comments