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. …

It is only the LEAKPROOF keyword that requires super user access, and it is a small optimization. You can leave the function in but remove the word LEAKPROOF.

Not sure what tools you have for said instance. Can’t you just log in to some kind of console, enter psql and 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 yo…

Interesting … Didn’t know about that. Huge :+1: for this!

Elixir Programming Language Forum

Only superuser can define a leakproof function

Questions & Help Questions

Eiji August 14, 2024, 2:30pm 4

Interesting … Didn’t know about that. Huge for this!