michelp / pgjwt

PostgreSQL implementation of JWT (JSON Web Tokens)
MIT License
368 stars 60 forks source link

Prefix pgcrypto hmac function with @extschema@ #10

Closed twopoint718 closed 5 years ago

twopoint718 commented 5 years ago

This PR resolves #6

It sounds like, quoting the Postgres docs:

https://www.postgresql.org/docs/10/extend-extensions.html#EXTEND-EXTENSIONS-RELOCATION

If any prerequisite extensions are listed in requires in the control file, their target schemas are appended to the initial setting of search_path. This allows their objects to be visible to the new extension's script file.

pgcrypto is listed in the control file so it should be available within this extension via @extschema@. And indeed, this fixes the issue for me.

Thanks!

michelp commented 5 years ago

Thanks @twopoint718 !