[postgis-tickets] [PostGIS] #4739: st_dwithin : no spatial operator found

[PostGIS]

#4739: st_dwithin : no spatial operator found
----------------------+---------------------------
 Reporter:  grantfin  |      Owner:  pramsey
     Type:  defect    |     Status:  new
 Priority:  medium    |  Milestone:  PostGIS 3.1.0
Component:  postgis   |    Version:  3.0.x
 Keywords:            |
----------------------+---------------------------
 I did look at prior issues, but they seemed much older, and possibly using
 SQL versions.

 **Product versions**


 {{{
 select postgis_full_version();
 postgis_full_version
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
  POSTGIS="3.0.1 ec2a9aa" [EXTENSION] PGSQL="120" GEOS="3.8.1-CAPI-1.13.3"
 PROJ="6.2.1" LIBXML="2.9.10" LIBJSON="0.13.1" LIBPROTOBUF="1.3.2"
 WAGYU="0.4.3 (Internal)"

 select version();
                                                    version
 -------------------------------------------------------------------------------------------------------------
  PostgreSQL 12.3 on x86_64-apple-darwin16.7.0, compiled by Apple LLVM
 version 8.1.0 (clang-802.0.42), 64-bit

 }}}

 **Replication steps**


 {{{
 create database geo_test;
 \c geo_test
 create extension postgis;
 create schema test;
 set search_path to test;
 create table a (lat float8, lng float8, idx_col public.geography generated
 always as (public.st_makepoint(lng,lat)::public.geography)stored);
 create index idx_a_geog on a using gist(idx_col);
 with g as (select public.st_makepoint(28,28)::public.geography a) select *
 from a, g where public.st_dwithin(g.a, a.idx_col, 5000, true);
 ERROR:  no spatial operator found for 'st_dwithin': opfamily 603008 type
 602965

 }}}

 ''Now, include the public schema...''


 {{{
 set search_path to test, public;
 SET
 with g as (select public.st_makepoint(28,28)::public.geography a) select *
 from a, g where public.st_dwithin(g.a, a.idx_col, 5000, true);
  lat | lng | idx_col | a
 -----+-----+---------+---
 (0 rows)
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4739>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.