kaido vaikla <kaido.vaikla@gmail.com> writes: > Why update can't find an extension, while i can describe it and search_path > seems to be correct?
Extension scripts are not run with the session's prevailing search_path, but with a search path built from the extension's dependencies. In this case, schema postgis would be included in that path only if extension postgis_topology specifies
requires = 'postgis'
in its postgis_topology.control file. It kinda sounds like that might be missing? If it's present, then Ron's thought about missing access privileges for the postgis schema might be the answer.
