DEV Community

Beaver Bridge
Beaver Bridge

Posted on

function gen_salt(unknown, integer) does not exist

새 사용자를 만들고 권한도 다 준 것 같은데 function gen_salt(unknown, integer) does not exist 이런 식으로 찾지 못할 때가 있다.

이럴 때는 schema를 정확히 지정해서 사용하게 해야한다.

select extensions.gen_salt(unknown, integer);
Enter fullscreen mode Exit fullscreen mode

그래도 못 찾는다면 extensions을 public하게 만들어서 테스트 해보자.

grant usage on schema extensions to public;
Enter fullscreen mode Exit fullscreen mode

Top comments (0)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay