Re: How to debug extension update - Mailing list pgsql-admin

From kaido vaikla
Subject Re: How to debug extension update
Date
Msg-id CA+427g9UOgYY4NMSzxcwXiZfwx9P5+b7bLXmEBYM8nx7FTigGQ@mail.gmail.com
Whole thread Raw
In response to Re: How to debug extension update  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin


On Tue, 14 Jan 2025 at 16:27, Tom Lane <tgl@sss.pgh.pa.us> 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

pgsql-admin by date:

Previous
From: Siraj G
Date:
Subject: Re: Performance issue - Seq Scan
Next
From: Andreas Froede
Date:
Subject: Re: Move datapath