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 1tUqIF-003Cqs-4F for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 16:49:31 +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 1tUqIE-00AJsI-F1 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 16:49:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUqIE-00AJsA-3t for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 16:49:29 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUqIB-000BH5-2C for pgsql-admin@postgresql.org; Mon, 06 Jan 2025 16:49:28 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-e5390ed85a1so19732120276.1 for ; Mon, 06 Jan 2025 08:49:27 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736182167; x=1736786967; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=Nbgt+FJxW6+1HNAPcCqmLPhfum/MIB5NGxTDDNnncmE=; b=cdWYuoqf/RoeY/dq1lsFXFfYdmXg+v23WRiNODOPoaTkPdkV8P7TmTqjlhQOXtf44V IXV+wN8ksgMQdXUmk6mdJLBozjql++M3QIxYhBR2RDL1lg7NrHDxUeeIiY8QYmCeB5K/ ZD7d5saC3cLgNqHf+2j3niAi+YfCfCo19lCt0ubCgaC8/uy1dQATnqepRYC5YNEbiyH6 8A7QX6NARvuk6rj83KT4V7DbCPgmgCjX9bYTqiKtR+icvy8/m8v+L0ELxdR9y+V/KshV STQNfsGY+kX70eoFQecMufMAKh+4V7pMn12Al5DF7DtUNikn0PbvN22/k6BFTp8zGgmR T1MQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736182167; x=1736786967; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=Nbgt+FJxW6+1HNAPcCqmLPhfum/MIB5NGxTDDNnncmE=; b=k2DMBja+1hDfRolF+SxbKX1TcuzzBBkJHvOlHOz8paJGsUNTqDyel6pY9FgvUaMEXY vGsbhNrTy4F8x110t6NTpIPNQtGpafLtswYAOWMyyoeAO07l5CSkUt4pomvW9/osPg+g HSP6e680CDauIQk6NNSPX0WAyvJQlzcQHweb2H1sEMrf0k2NpWMuGdwJw0sqYZt3n0d+ VbO1Blk5C4kxU9tLqKFvCJ8Z10BzXepdkZ0dGYHumrOla/p0C49xhyJwOSKcrDU6d75D XQBoMroXfm1NmOTVWoQ2aZ9teFR+YhF0uxBc7zI4j2rnoj8QRVEe2BA+qmhnU220Ibiy MFnA== X-Gm-Message-State: AOJu0YyrKtK329xHcwEzaqJu/n/kNyRToJktZYrObEFJpiqiuP5S8K0J F4Dk8mU54BnR0LC2S/iap4pk6b0RfsbdOOxSk4y3YM6fbBcVO6GVKw193SRDJtklOzd94FWc84s lMdtitbXLOLCm9UxZuOeXeY+602BRpAqT X-Gm-Gg: ASbGncuGToynizdcpJGV4DfX2CzYTEAihIFI70jhPnqIvkPUyYn+8ALwjExvSMoMIAe Y66LF+IorYoq0VBEUoofZtMtV/YRwNx6UZylmpw== X-Google-Smtp-Source: AGHT+IH1R1toGjnKGB1YLqIvq3NEvO2UXhCBmB8/67niMTaXZcIR0uO13B6DWVnzIIzw3Wg0V1CQ1mDw5qW2lAngKNs= X-Received: by 2002:a25:4889:0:b0:e39:80b9:3344 with SMTP id 3f1490d57ef6-e538c208e83mr26560081276.3.1736182167309; Mon, 06 Jan 2025 08:49:27 -0800 (PST) MIME-Version: 1.0 From: kaido vaikla Date: Mon, 6 Jan 2025 18:49:16 +0200 Message-ID: Subject: How to debug extension update To: pgsql-admin Content-Type: multipart/alternative; boundary="0000000000005917ac062b0c69d8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005917ac062b0c69d8 Content-Type: text/plain; charset="UTF-8" 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? br Kaido --0000000000005917ac062b0c69d8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,=C2=A0

Updating extension fails:
ERROR: =C2=A0type = does not exist
but i can describe it, ie search_path is correct.
pg v= ersion 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?

br
Kaido

--0000000000005917ac062b0c69d8--