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 1tZqQO-00DcAQ-TC for pgsql-admin@arkaria.postgresql.org; Mon, 20 Jan 2025 11:58:37 +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 1tZqPP-001GK6-0i for pgsql-admin@arkaria.postgresql.org; Mon, 20 Jan 2025 11:57:35 +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 1tZqPO-001GJy-KA for pgsql-admin@lists.postgresql.org; Mon, 20 Jan 2025 11:57:35 +0000 Received: from mail-yb1-xb33.google.com ([2607:f8b0:4864:20::b33]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tZqPM-000Wpl-0p for pgsql-admin@postgresql.org; Mon, 20 Jan 2025 11:57:34 +0000 Received: by mail-yb1-xb33.google.com with SMTP id 3f1490d57ef6-e53ef7462b6so6698540276.3 for ; Mon, 20 Jan 2025 03:57:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737374251; x=1737979051; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=DsAVDk97RICABn5NAQHuZMwrL8Z8qt7lHSYgxjGwciM=; b=IF8dDQuplPGqkB6/uui9jNe7F4woo0b9XEqZ9gVbBfijZq52SmJL8iuiWwll86qSLV 13kNvXNcVCaPprGa9UifnCd0BjKQDFEKbX9WwwwJj6FRtLrQoxsk3VyDaraz61BatJwi ib1RD9MxOrSjSRafbGQ4V9h22oXPgD71fyNrf9/qjGjPVGpymvsxxTE4BBhR0tbmZOSf 6AFy8WwYAF3fSSGbZwISNaPYLfaVAXiAGbva75MnKEKWjQib0osOAYaEqVUFpYg7x8xs k5drOxGsOTzA0h6OT3hNk1CUSYOvWMlX3cL1b4fhGUYEHpxFFxCrEVe1+hV3AFFFjmx/ e9Bg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737374251; x=1737979051; h=cc: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=DsAVDk97RICABn5NAQHuZMwrL8Z8qt7lHSYgxjGwciM=; b=iMXz+4KRSNKeM5WQF5bGxp+HwOutiF6NSu569WQo9cELsmGxGnsqWprKV8KHs6UNKq KT4tTgzSbXHrtrWetBHmTI4BPJBAmLPB1qZlRwx0hMUWXYXGsC44Sd+oYbMLsvNNo2vS E+hYdTQNvgcD26NQuu1/WQKpCxwRktKDF6217g5ulJlnS2NAoovnbHlGeQMnliVLVy9l 2Gd37xLnb9RW1wvD0MRdLRF/XO58Jk/YxR22TR5rb7UD0RkpwNxgjclrMCg5pfjkEBzB eXBk7Cu/JqtLNSdPuO2ckBspZTzGVbkDIfy0gczRYAm1N5wLxvhSUn8HGmpLnm1uGdZI 1SOg== X-Forwarded-Encrypted: i=1; AJvYcCUzcywcZvxWKvX48MO2xOVO49pbiSKh16IMGMPrIzvtidZyvtnGUoYWyI17eMeiyCjIInQL+25wxaiEfQ==@postgresql.org X-Gm-Message-State: AOJu0Yw2KZBd+hcFOIJHxDcWVsRXRkY0/6IGTqPylASJBsN1ML1fCdvS o4i42asnFsYUY/T4usRHzhCqV68DWb86fRHuMwLz2JCaT7elDg9Dc/oh0H5c66QBAfRx98MCla6 ASosG42Yx0vmFVjyqJmk5YCdvTiM= X-Gm-Gg: ASbGncvC7MLv35Fd/+xwM67CYFEkRuzsgKNwLJ1BKhxGsN7KwzolQ5g2ivak3laihtW gAjLJspVEJ81nv1hQgguLXLG2OpSgtct2YAtzJvi84a9/CmWOye0= X-Google-Smtp-Source: AGHT+IEO3fVf6VWX4fs6y52FySOlkDto7d5nRwddJxMAIfhAUSZURRzewxtyvjhj55fl2AgzO6Y10y74/9Mmmfj6DcA= X-Received: by 2002:a05:6902:1383:b0:e57:33ac:9df4 with SMTP id 3f1490d57ef6-e57b1097d4cmr8544099276.28.1737374250785; Mon, 20 Jan 2025 03:57:30 -0800 (PST) MIME-Version: 1.0 References: <1334421.1736193470@sss.pgh.pa.us> <680730.1736864873@sss.pgh.pa.us> In-Reply-To: <680730.1736864873@sss.pgh.pa.us> From: kaido vaikla Date: Mon, 20 Jan 2025 13:57:19 +0200 X-Gm-Features: AbW1kvYItdDBH4tuzbhFt6oSC2Ezh2LRU6oAAQzshIIMF5R__r6VnJGgpJLHppE Message-ID: Subject: Re: How to debug extension update To: Tom Lane Cc: Zaid Shabbir , pgsql-admin Content-Type: multipart/alternative; boundary="0000000000000f67cb062c21f750" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000f67cb062c21f750 Content-Type: text/plain; charset="UTF-8" On Tue, 14 Jan 2025 at 16:27, Tom Lane wrote: > What I was suspicious of is whether you have "usage" privilege on the > schema that the postgis datatype is installed in. The above command > would not tell you that. > > regards, tom lane > usage privilege exists: teglms=# \dT geometry List of data types Schema | Name | Description ---------+----------+-------------------------------------------------------------------------------------- postgis | geometry | postgis type: The type representing spatial features with planar coordinate systems. (1 row) teglms=# \dn+ postgis List of schemas Name | Owner | Access privileges | Description ---------+------------+------------------------------+------------- postgis | eglmsadmin | eglmsadmin=UC/eglmsadmin +| | | gr_postgis_r=U/eglmsadmin +| | | gr_postgis_rw=U/eglmsadmin +| | | gr_postgis_rwx=UC/eglmsadmin | (1 row) br Kaido --0000000000000f67cb062c21f750 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


On Tue, 14 Ja= n 2025 at 16:27, Tom Lane <tgl@sss.= pgh.pa.us> wrote:
What I was suspicious of is whether you have "usage" p= rivilege on the
schema that the postgis datatype is installed in.=C2=A0 The above command would not tell you that.

=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 regards, tom lane

usage privilege exists:
teg= lms=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 List of data types
=C2=A0Schema =C2=A0| = =C2=A0 Name =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 D= escription
---------+----------+----------------------------------------= ----------------------------------------------
=C2=A0postgis | geometry = | postgis type: The type representing spatial features with planar coordina= te systems.
(1 row)

teglms=3D# \dn+ postgis
=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 L= ist of schemas
=C2=A0 Name =C2=A0 | =C2=A0 Owner =C2=A0 =C2=A0| =C2=A0 = =C2=A0 =C2=A0Access privileges =C2=A0 =C2=A0 =C2=A0 | Description
------= ---+------------+------------------------------+-------------
=C2=A0post= gis | eglmsadmin | eglmsadmin=3DUC/eglmsadmin =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| gr_pos= tgis_r=3DU/eglmsadmin =C2=A0 +|
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| gr_postgis_rw=3DU/eglmsadmin =C2=A0= +|
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0| gr_postgis_rwx=3DUC/eglmsadmin |
(1 row)

br
Kaid= o
--0000000000000f67cb062c21f750--