jason.o
My recent Ash postgres migration includes the following, and it’s causing the above error on Render.com because their managed postgres instance doesn’t allow for superuser access.
Should I remove this migration? I want to make sure it’s not going to cause issues elsewhere in the framework. Thanks.
CREATE OR REPLACE FUNCTION timestamp_from_uuid_v7(_uuid uuid)
RETURNS TIMESTAMP WITHOUT TIME ZONE
AS $$
SELECT to_timestamp(('x0000' || substr(_uuid::TEXT, 1, 8) || substr(_uuid::TEXT, 10, 4))::BIT(64)::BIGINT::NUMERIC / 1000);
$$
LANGUAGE SQL
IMMUTABLE PARALLEL SAFE STRICT LEAKPROOF;
Where Next?
Trending in Questions
Other Trending Topics
Latest Ash Threads
Latest on Elixir Forum
Sponsor Spotlight
Master modern tools, write cleaner code, and tackle real-world challenges with Manning books, videos, and courses. Start building today.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #elixirconf-us
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #security
- #elixirconf-eu
- #api
- #forms
- #performance
Our Sponsors
Build Elixir applications with speed and confidence.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Elixir, Erlang & BEAM conferences from Code Sync - join us in 2026!
Practical resources that improve the lives of professional developers.
Bringing learning, work and compliance together since 1987.
Producing high quality Elixir screencasts since 2017.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
Eiji
Not sure what tools you have for said instance. Can’t you just log in to some kind of console, enter
psqland grant required privileges to non-superuser account?I have used custom
PostgreSQL’s functions many times and I do not imagine that somebody would prevent me from using so useful API.If you ask me I understand why someone may not want superuser access for apps, but I don’t see why some privileges shouldn’t be allowed to grant for a desired
postgresaccount … I would not limit your features because somebody blindly follows some security concepts.At most you could make it configurable and disable some features in specific cases, but it shouldn’t affect everyone. Look that almost nobody knows my phone number. Should we now prevent apps from using phone numbers? In this case how we would do a phone calls? On the other side is me who does not have much phone calls as expected.
zachdaniel
It is only the
LEAKPROOFkeyword that requires super user access, and it is a small optimization. You can leave the function in but remove the wordLEAKPROOF.Eiji
Interesting … Didn’t know about that. Huge
for this!