fix(schemas): explicitly set search path

logto-io / logto

🧑‍🚀 The better identity infrastructure for developers and the open-source alternative to Auth0.

https://logto.io

Mozilla Public License 2.0

7.86k stars 386 forks source link

fix(schemas): explicitly set search path #6101

Closed gao-sun closed 3 weeks ago

gao-sun commented 3 weeks ago

Summary

In Logto Cloud, we have multiple schemas and the default search behavior will be problematic. This alteration script will fix it by setting the search path to public for the functions.

Testing

locally ran a cloud test set, no error

Checklist

[ ] .changeset
[ ] unit tests
[ ] integration tests
[ ] necessary TSDoc comments

github-actions[bot] commented 3 weeks ago

COMPARE TO `master`

Total Size Diff :chart_with_upwards_trend: +838 Bytes

Diff by File

|Name|Diff| |---|---| |packages/schemas/alterations/next-1719221205-fix-functions.ts|:chart_with_upwards_trend: +788 Bytes| |packages/schemas/tables/applications.sql|:chart_with_upwards_trend: +25 Bytes| |packages/schemas/tables/organization_roles.sql|:chart_with_upwards_trend: +25 Bytes|