function st_contains(sde.st_geometry, sde.st_geometry) does not exist

0
votes

Please help, I tried using PostGIS ST_Contains function on Laravel

SQLSTATE[42883]: Undefined function: 7 ERROR: function st_contains(sde.st_geometry, sde.st_geometry) does not exist

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

  • Laravel Framework 6:13.1
  • PostgreSQL 9.6.15
  • PostGIS 2.4

This SQL query works fine if run in pgAdmin.

1
phplaravelpostgresqlgispostgis

1 Answers

0
votes

You probably have to qualify the function with the name of the schema that contains it: sde.st_contains

The explanation is that the schema is not on your search_path.