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

[Regina Obe]

Usually the reasons I get that error are 

 

1.	You did not reconnect after setting search_path of the database. The search path if set at the db level, does not take effect until after reconnection.
2.	You did not give permissions to those functions or usage to the schema.

 

From: Bharath Tadikonda <tadikondabharath at gmail.com> 
Sent: Friday, June 21, 2024 9:06 AM
To: postgis-users at lists.osgeo.org
Subject: ERROR : function st_astext(postgis.geometry) doesn't exist

 

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 

 



 

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

 



 

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/e964e8f0/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 59681 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240621/e964e8f0/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 18146 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240621/e964e8f0/attachment-0001.png>