Pgsql： ERROR: cache lookup failed for operator family 0

Question

select "XXX" from "XXX" s,(SELECT ST_GeomFromText('WKT数据')) t where st_intersects(t."geom",s."smgeometry") = TRUE;
报错 cache lookup failed for operator family 0
怎么解决
====================================
好像是这个函数的问题st_intersects（）这个函数怎么用

Answer 1

你看看表字段的字符是啥？我觉得是字符类型的问题
https://desktop.arcgis.com/zh-cn/arcmap/10.7/manage-data/using-sql-with-gdbs/st-intersects.htm