Create database fails on Azure Postgres Flexi Server

[simonFuturePerfect]

Background

When setting up the script line

ALTER FUNCTION jsonb_path_query(jsonb,jsonpath,jsonb,boolean) ROWS 1

Fails because the function's owner is 'azuresu' as this is a PAAS only Microsoft have access to the 'Super User Account'

Is there any other way around this ?

Enhancement

Is it possible to have a SQL script that does not require these elevated privileges ?

Discussion

No response

Further information

No response

[stefanspiska]

You can remove

ALTER FUNCTION jsonb_path_query(jsonb,jsonpath,jsonb,boolean) ROWS 1

since it is just a minor optimization.

[simonFuturePerfect]

Thank for that @stefanspiska your swift feedback is very much appreciated.

[vladislavploaia]

Hello @simonFuturePerfect,
Based on Stefan's feedback, is there anything else we can support with or ticket can be closed?

CC: @vidi42

[simonFuturePerfect]

I would close this ticket. Any other issues I can raise separately.

Thanks for all the help.