[postgis-tickets] [SCM] PostGIS branch master updated. 3.1.0rc1-32-ga3c1c63

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, master has been updated
       via  a3c1c6310db8063b219b3e910ca249352345f048 (commit)
      from  95c2fbe56f71d42e0f15e008c3bbee6a0b41c40b (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit a3c1c6310db8063b219b3e910ca249352345f048
Author: Regina Obe <lr at pcorp.us>
Date:   Tue Jan 5 07:35:17 2021 -0500

    Set row estimate to 1 and mark as parallel safe the geocode function.  References #4822 for PostGIS 3.2 (master)

diff --git a/extras/tiger_geocoder/geocode/geocode.sql b/extras/tiger_geocoder/geocode/geocode.sql
index 50899fe..34df34f 100644
--- a/extras/tiger_geocoder/geocode/geocode.sql
+++ b/extras/tiger_geocoder/geocode/geocode.sql
@@ -33,7 +33,9 @@ BEGIN
   RETURN QUERY SELECT g.addy, g.geomout, g.rating FROM geocode(ADDY, max_results, restrict_geom) As g ORDER BY g.rating;
 
 END;
-$_$ LANGUAGE plpgsql STABLE;
+$_$ LANGUAGE plpgsql COST 1000
+STABLE PARALLEL SAFE
+ROWS 1;
 
 CREATE OR REPLACE FUNCTION geocode(
     IN_ADDY NORM_ADDY,
@@ -125,5 +127,7 @@ BEGIN
   RETURN;
 
 END;
-$_$ LANGUAGE plpgsql STABLE
-  COST 1000;
+$_$ LANGUAGE plpgsql
+COST 1000
+STABLE PARALLEL SAFE
+ROWS 1;

-----------------------------------------------------------------------

Summary of changes:
 extras/tiger_geocoder/geocode/geocode.sql | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)


hooks/post-receive
-- 
PostGIS