If an immutable fn is used from other role, problems arise, this is regression versus ver2.2 and XL:
SELECT sourceid
FROM timeseriesresult
WHERE runid=62 and catalogid=getmaincatalog() and ftimeseriestype = gettsresulttypeid(62,'RemoveOutlierPerTransitOperator_G_CCD')
limit 10
ERROR: permission denied to set session authorization
if any of the fn involved has SECURITY DEFNER on.
If an immutable fn is used from other role, problems arise, this is regression versus ver2.2 and XL:
if any of the fn involved has
SECURITY DEFNERon.