New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Migration installing extension "citext" required superuser privilege #5

Open

BrucePerens opened this issue Mar 10, 2021 · 1 comment

BrucePerens commented Mar 10, 2021

penny/db/migrations/20210208231305_make_email_columns_case_insensitive.cr

Line 3 in be23e9a

enable_extension "citext"

I had to grant superuser privilege to my database user before I could run this migration successfully.

Contributor

akadusei commented Mar 11, 2021

My understanding is that citext is trusted by default. Unless the config is overridden somewhere in your own environment, it should not require superuser privilege. See https://www.postgresql.org/docs/current/extend-extensions.html#id-1.8.3.20.11

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