Skip to content

Instantly share code, notes, and snippets.

@deterralba

deterralba/pgrowlocks.md

Created August 15, 2018 14:17
Show Gist options
  • Save deterralba/fd6a1f901aa66f74631f9c8d17fe819c to your computer and use it in GitHub Desktop.
Save deterralba/fd6a1f901aa66f74631f9c8d17fe819c to your computer and use it in GitHub Desktop.
Download ZIP
pgrowlocks: HINT: No function matches the given name and argument types.
Raw
pgrowlocks.md

In postgresql postgres, if you encounter the error

HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

when trying to run pgrowlocks, you probably need to create its extension: CREATE EXTENSION pgrowlocks;.

See the documentation: https://www.postgresql.org/docs/9.6/static/contrib.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment