public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: kaido vaikla <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: How to debug extension update
Date: Mon, 06 Jan 2025 14:57:50 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>
References: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>

kaido vaikla <[email protected]> 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.

			regards, tom lane

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: How to debug extension update
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox