Question
How to change extra_float_digits on Managed PostgreSQL DB?
- Posted on October 3, 2022
- DigitalOcean Managed PostgreSQL Database
Asked by BigTurquoiseSeal
I need to change extra_float_digits but an error occurs
could not execute query: ERROR: must be superuser to create an operator class
Submit an answer
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hollie's Hub for Good
Working on improving health and education, reducing inequality, and spurring economic growth? We’d like to help.
Get started for free
Enter your email to get $200 in credit for your first 60 days with DigitalOcean.
New accounts only. By submitting your email you agree to our Privacy Policy.
Hi there,
You can do this by using the DigitalOcean API. You can now configure your PostgreSQL Managed Databases by making a
PATCHrequest to/v2/databases/{database_cluster_uuid}/config. For more information, you can check out the official API documentation here:https://docs.digitalocean.com/reference/api/api-reference/#operation/databases_patch_config
However, if the configuration that you want to change is not in the list, please reach out to our amazing support team who might be able to change this for you!
Hope that helps!
- Bobby.