ERROR: function uuid_generate_v4() does not exist (SQLSTATE 42883) about supa_audit

Hi @olirice

Thanks for your fast replay! I have extended the uuid_generate_v* references with the extensions prefix and everything is working as expected now - an easy change once you know where to. I was confuse as select uuid_generate_v4(); (also without prefix) worked as expected. Further I have some own functions using uuid_generate_v4() as well, also without prefix...
May it would be good to have this mentioned somewhere in README.md.

Best an tx again

[olirice]

hi @mableu

supabase installs uuid-ossp in the extensions schema i.e. extensions.uuid_generate_v4. The reason you're seeing this is because, in supa_audit, we don't explicitly specify the schema prefix on those function calls. That decision is intentional, so supa_audit can be compatible with installing uuid-ossp anywhere in the database so long as the it is on the executing postgres roles' search_path.

The knobs to manipulate search_path for different roles are available to you on the platform, but the safest & most reliable solution would be to update the 2 references to uuid_generate_v* to include the schema prefix extensions.uuid_generate_v* in the supa_audit SQL file here

let me know if that gives you any trouble