function st_within - e
|Reported by:||giau81||Owned by:||robe|
|Keywords:||st_within, st_Contains, search_path||Cc:|
st_within(geometry, geometry)/st_Contains(geometry, geometry) call 'SELECT $1 && $2 AND _ST_Contains($2,$1)' without setting public schema to _ST_Contains function.
Using "set search_path = schema_name", if schema_name is not "public", the functions st_within(geometry, geometry)/st_Contains(geometry, geometry) don't work, because they call schema_name._ST_Contains($2,$1) instead of public._ST_Contains($2,$1).
This problem happens during db restoring processes. We solve this issue modifying the function like this: 'SELECT $1 && $2 AND public._ST_Contains($2,$1)'
Change History (4)
comment:1 Changed 11 months ago by robe
- Summary changed from function st_within to function st_within - e