public inbox for [email protected]
help / color / mirror / Atom feedFrom: kaido vaikla <[email protected]>
To: Zaid Shabbir <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: pgsql-admin <[email protected]>
Subject: Re: How to debug extension update
Date: Tue, 14 Jan 2025 12:16:29 +0200
Message-ID: <CA+427g9ZYRqRO42WN=fkxiZhLBZA53xps+1mJXR3jB7Sc2j5-w@mail.gmail.com> (raw)
In-Reply-To: <CABCJe_Wu8K0jteiN-JM_Grhy8fL1WKeH7UrWk_1TpOwumoR-nQ@mail.gmail.com>
References: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>
<[email protected]>
<CABCJe_Wu8K0jteiN-JM_Grhy8fL1WKeH7UrWk_1TpOwumoR-nQ@mail.gmail.com>
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 <[email protected]> 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 <[email protected]> wrote:
>
>> 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], [email protected]
Subject: Re: How to debug extension update
In-Reply-To: <CA+427g9ZYRqRO42WN=fkxiZhLBZA53xps+1mJXR3jB7Sc2j5-w@mail.gmail.com>
* 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