public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Re: How to debug extension update
Date: Mon, 6 Jan 2025 12:48:54 -0500
Message-ID: <CANzqJaCMRrhfRe9bOR8zqH1+K+Vq2qzTyiwYMfizHPs7SL=+qA@mail.gmail.com> (raw)
In-Reply-To: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>
References: <CA+427g80oqbNoq4JJYH0Y6rX=p32_ZhRzaEeECQV9TAN_UqjRw@mail.gmail.com>
On Mon, Jan 6, 2025 at 11:49 AM kaido vaikla <[email protected]> wrote:
> Hi,
>
> Updating extension fails:
> ERROR: type does not exist
> but i can describe it, ie search_path is correct.
> pg version 15.10.
>
>
> teglms=# \dx post*
> List of installed extensions
> Name | Version | Schema | Description
>
> ------------------+---------+----------+------------------------------------------------------------
> postgis | 3.3.6 | postgis | PostGIS geometry and geography
> spatial types and functions
> postgis_raster | 3.3.6 | postgis | PostGIS raster types and functions
> postgis_topology | 3.3.3 | topology | PostGIS topology spatial types
> and functions
> (3 rows)
>
> teglms=# alter extension postgis_topology update to "3.3.6";
> ERROR: type "geometry" does not exist
> teglms=# \dT+ geometry
> List of data
> types
> Schema | Name | Internal name | Size | Elements | Owner |
> Access privileges | Description
>
> ---------+----------+---------------+------+----------+------------+-------------------+----------------------------------------------
> postgis | geometry | geometry | var | | eglmsadmin |
> | postgis type: The type representing spatial .
> | | | | | |
> |.features with planar coordinate systems.
> (1 row)
>
> teglms=# select user;
> user
> ------------
> eglmsadmin
> (1 row)
>
> teglms=# show search_path ;
> search_path
> -------------------
> postgis, topology
> (1 row)
>
> Why update can't find an extension, while i can describe it and
> search_path seems to be correct?
>
>
Type geometry is owned by eglmsadmin, but there do not appear to be any
Access privileges granted. Thus, maybe whatever user you connected as
doesn't have privs to access it?
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
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]
Subject: Re: How to debug extension update
In-Reply-To: <CANzqJaCMRrhfRe9bOR8zqH1+K+Vq2qzTyiwYMfizHPs7SL=+qA@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