Re: Function not displaying PARALLEL SAFE on SQL tab

Thanks, logged here: https://redmine.postgresql.org/issues/2089

On Tue, Jan 17, 2017 at 6:13 PM, Shira Bezalel <shira(at)sfei(dot)org> wrote:
> I'm reviewing some PostGIS functions in pgAdmin 4. When I click on the SQL
> tab, I notice that the "PARALLEL SAFE" qualifier doesn't show up. But when I
> do an "\sf" on one of these functions in psql, I see the syntax (but not the
> NOT LEAKPROOF). Is this a known issue? I looked through issues list, but
> didn't see anything similar. For now, is the psql output the most accurate?
>
> SQL tab from pgAdmin 4:
>
> CREATE OR REPLACE FUNCTION public.st_intersects(
> geom1 geometry,
> geom2 geometry)
> RETURNS boolean
> LANGUAGE 'sql'
> COST 100.0
> IMMUTABLE NOT LEAKPROOF
> AS $function$
> SELECT $1 OPERATOR(public.&&) $2 AND public._ST_Intersects($1,$2)
> $function$;
>
>
>
> psql output:
>
> mydb=# \sf st_intersects (geometry,geometry)
> CREATE OR REPLACE FUNCTION public.st_intersects(geom1 geometry, geom2
> geometry)
> RETURNS boolean
> LANGUAGE sql
> IMMUTABLE PARALLEL SAFE
> AS $function$SELECT $1 OPERATOR(public.&&) $2 AND
> public._ST_Intersects($1,$2)$function$
>
>
>
>
> Thanks,
>
> Shira Bezalel
>
>

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company