ERROR : function st_astext(postgis.geometry) doesn't exist

[Bharath Tadikonda]

Hello team,

A database user has encountered an ERROR : function
st_astext(postgis.geometry) doesn't exist while trying to query
st_astext(bbox) function

[image: image.png]

database search path is already set with 'postgis' but still sees the error.

[image: image.png]

Can you please advise what is the issue here?

Regards,
Bharath
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240621/b877800a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 59681 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240621/b877800a/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 18146 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240621/b877800a/attachment-0001.png>