From b977d19ccee2f29f132f5c3e38b0c50a4571ef1c Mon Sep 17 00:00:00 2001 From: Paul Ramsey Date: Fri, 17 Feb 2012 22:00:39 +0000 Subject: [PATCH] This works but it makes estimated extent case sensitive both ways (no weaseling out and giving upper case versions of lower case tables) (#1585) git-svn-id: http://svn.osgeo.org/postgis/trunk@9230 b70326c6-7e19-0410-871a-916f4a2858ee --- postgis/geometry_estimate.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/postgis/geometry_estimate.c b/postgis/geometry_estimate.c index 489c70ae0..e363430fd 100644 --- a/postgis/geometry_estimate.c +++ b/postgis/geometry_estimate.c @@ -1399,11 +1399,11 @@ Datum geometry_estimated_extent(PG_FUNCTION_ARGS) superuser (by marking the function as SECURITY DEFINER) and check permissions ourselves */ if ( txnsp ) { - sprintf(query, "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), '%s.%s', 'select')", nsp, tbl); + sprintf(query, "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), '\"%s\".\"%s\"', 'select')", nsp, tbl); } else { - sprintf(query, "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), '%s', 'select')", tbl); + sprintf(query, "SELECT has_table_privilege((SELECT usesysid FROM pg_user WHERE usename = session_user), '\"%s\"', 'select')", tbl); } POSTGIS_DEBUGF(4, "permission check sql query is: %s", query); -- 2.40.0