Postgres - PostGIS extension is working under public schema


Postgres needs an extension PostGIS for a work with a Geography a DataType.
After install and enable the extension in database, it starts work under a public schema.


An Origam project doesn´t work under public schema. The PostgreSQL throws an error “PostGIS functions not exists” if start this function from different schema than public.

A solution

For this type of error is add public schema into default search path.

1 Like

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.