Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUrE0-003Krc-ET for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 17:49:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tUrDz-00Aq6G-5k for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 17:49:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUrDy-00Aq4n-PY for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 17:49:10 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUrDv-000CXZ-1Z for pgsql-admin@postgresql.org; Mon, 06 Jan 2025 17:49:10 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-2a01bcd0143so10265762fac.2 for ; Mon, 06 Jan 2025 09:49:08 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736185746; x=1736790546; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=Zt1CObDkaHdQZ5k5aG5BPqmfgRzcrES6spjeA9WtIc0=; b=krFQoDvPYEg66eXmYMmaM5vPj2ZMH//6ucxHopDcRTZSWeIfg1Kk0uQMSZbAGfBYtV q/LXP/lBBPSKpGD2nY6EbXhDIXeN4aXAEV1/O67pR+5KI75OqNB+ozbXtM32iEZBVpSP PfxzPucJSwI4jN+ReSEeDZIpMgUO8zMKlG39IiwOcxIbuKot1hTsBNec3vzm2dNsa06Y yFpQ9IwfYuRaFWAczmZX7MFHr1+gPm7Yaa/YMtleqDGpaZjdtR34aNpwvA5oJNxBC6mH b3AsFgBC0JFa5r03fDks6DeCONPeKnkBYCeprC9IS/5cZSkkI6FHj4tUlehOu7V6/MS+ mEUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736185746; x=1736790546; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Zt1CObDkaHdQZ5k5aG5BPqmfgRzcrES6spjeA9WtIc0=; b=Lk3xQ7U3g/8JuTMncn3OVq6Yd0F4hon/kkoKn/uY1o67MCYjmGznMK6A1vFPLI7jp/ A4nYOhCUFpAki7fqKZR3sRlY5Fu9xa8EP7xonamMLlAmZn9T32j0iEKCf2R2UR8qK7C4 tNPVouOhVH73S290o8tEqIiOUEZ8I1faAI42WDx81uN6EADAtFN27r9t+YDDb1aQyj53 Bi9hvSWlvgkoxq0ZBHSJsgIPjmrbNcHqokYm9YzGtr739okKstivN53k3dN2luL34JQk V7V23/bzKF6O7Y3D7lYEV/saUTPpawQFDxDyzJwPkaBNyy1m5LnIjvC7qQlatVrZHd2O nRiQ== X-Gm-Message-State: AOJu0YyD1iSV4hhtqJCKknVLku42L+hVGIFVBhlRB8kOF2O4hHRKtkbi pm++u+H2ghHe1FC6NwiI6fmbVZJqQAQn+7tMphDRasTIrmw7KhZ8FllGf8DzTYFZNQN1VyRe/+Z rLvIbLrcb4yBkZhJGcshkJ0wfIpyOqj0b X-Gm-Gg: ASbGncuP86mNET6cmNgQeMSliF+x5fu2BJkzj0u02cFKEg9hwCFUueGbEUxY1v8e8zg +XgWmIVrFlLxELY0hTRuKSaKyS7j7HeJG2sn8HJA= X-Google-Smtp-Source: AGHT+IHzalvkqyn+ImDu9PTSNLFqBZjkOu2r6GHJWJPI+exvK08tREOjZoXp5vOk8Q+cmWE7hJMfiI+bGYUONtYXUOc= X-Received: by 2002:a05:6871:28e:b0:287:4904:7125 with SMTP id 586e51a60fabf-2a7fb08cef3mr31190906fac.14.1736185746099; Mon, 06 Jan 2025 09:49:06 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ron Johnson Date: Mon, 6 Jan 2025 12:48:54 -0500 Message-ID: Subject: Re: How to debug extension update To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000a91695062b0d3e3c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a91695062b0d3e3c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Jan 6, 2025 at 11:49=E2=80=AFAM kaido vaikla 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=3D# \dx post* > List of installed extensions > Name | Version | Schema | Descripti= on > > ------------------+---------+----------+---------------------------------= --------------------------- > postgis | 3.3.6 | postgis | PostGIS geometry and geography > spatial types and functions > postgis_raster | 3.3.6 | postgis | PostGIS raster types and functio= ns > postgis_topology | 3.3.3 | topology | PostGIS topology spatial types > and functions > (3 rows) > > teglms=3D# alter extension postgis_topology update to "3.3.6"; > ERROR: type "geometry" does not exist > teglms=3D# \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=3D# select user; > user > ------------ > eglmsadmin > (1 row) > > teglms=3D# 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? --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000a91695062b0d3e3c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Jan 6, 2025 at 11:49=E2=80=AFAM k= aido vaikla <kaido.vaikla@gmai= l.com> wrote:
=
Hi,=C2=A0

Updating extension fails:
ERROR: =C2=A0typ= e does not exist
but i can describe it, ie search_path is correct.
pg= version 15.10.


teglms=3D# \dx post*
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 List of installed extensions
=C2=A0 =C2=A0 = =C2=A0 =C2=A0Name =C2=A0 =C2=A0 =C2=A0 | Version | =C2=A0Schema =C2=A0| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0Description
------------------+---------+----------+--------------= ----------------------------------------------
=C2=A0postgis =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| 3.3.6 =C2=A0 | postgis =C2=A0| PostGIS geometry a= nd geography spatial types and functions
=C2=A0postgis_raster =C2=A0 | 3= .3.6 =C2=A0 | postgis =C2=A0| PostGIS raster types and functions
=C2=A0p= ostgis_topology | 3.3.3 =C2=A0 | topology | PostGIS topology spatial types = and functions
(3 rows)

teglms=3D# alter extension postgis_topolog= y update to =C2=A0"3.3.6";
ERROR: =C2=A0type "geometry&qu= ot; does not exist
teglms=3D# \dT+ geometry
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 List of data types
=C2=A0Schema =C2=A0| = =C2=A0 Name =C2=A0 | Internal name | Size | Elements | =C2=A0 Owner =C2=A0 = =C2=A0| Access privileges | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 Description
---------+----------+---------------+------+-----= -----+------------+-------------------+------------------------------------= ----------
=C2=A0postgis | geometry | geometry =C2=A0 =C2=A0 =C2=A0| var= =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| eglmsadmin | =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | postgis type: The type repr= esenting spatial .
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2= =A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 |.features with planar coordinate systems.
(1 row)

teg= lms=3D# select user;
=C2=A0 =C2=A0 user
------------
=C2=A0eglmsad= min
(1 row)

teglms=3D# show search_path ;
=C2=A0 =C2=A0 search= _path
-------------------
=C2=A0postgis, topology
(1 row)

W= hy update can't find an extension, while i can describe it and search_p= ath seems to be correct?


Type=C2=A0geometry is owned by=C2=A0eglmsadmin, but ther= e do not appear to be any Access privileges granted.=C2=A0 Thus, maybe what= ever user you connected as doesn't have privs to access it?
<= br>
--
Death to <Redacted>, a= nd butter sauce.
Don't boil me, I'm still alive.
&= lt;Redacted> lobster!
--000000000000a91695062b0d3e3c--