Re: How to debug extension update

1) requires = 'postgis'

$ cat postgis_topology.control
# postgis topology extension
comment = 'PostGIS topology spatial types and functions'
default_version = '3.3.6'
relocatable = false
schema = topology
requires = postgis

So i changed it
requires = postgis -> requires = 'postgis'
but no help.

2) about missing access privileges
I checked different databases with
\dT+ *.*

data types "Access privileges" is everywhere empty.

As my subject is, is it there a way somehow debug "alter extension update"
statement to figure out what is going on behind this?

br
Kaido

On Mon, 6 Jan 2025 at 22:05, Zaid Shabbir <zaidshabbir(at)gmail(dot)com> wrote:

> Hello,
>
> I am also getting the same error without the upgrade scenario.
>
> postgres=# CREATE EXTENSION postgis SCHEMA postgis;
>
> CREATE EXTENSION
>
> postgres=# CREATE EXTENSION postgis_topology SCHEMA topology;
>
> ERROR: type "geometry" does not exist
>
> postgres=# show search_path ;
>
> search_path
>
> ---------------------------
>
> postgis, topology, public
>
> (1 row)
>
> postgres=# CREATE EXTENSION postgis_topology;
>
> ERROR: type "geometry" does not exist
>
> postgres=# SELECT current_schema();
>
> current_schema
>
> ----------------
>
> postgis
>
> (1 row)
>
> Regards,
> Zaid
>
>
>
>
> On Tue, Jan 7, 2025 at 12:58 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> kaido vaikla <kaido(dot)vaikla(at)gmail(dot)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.
>>
>> regards, tom lane
>>
>>
>>