Re: How to debug extension update
| От | kaido vaikla |
|---|---|
| Тема | Re: How to debug extension update |
| Дата | |
| Msg-id | CA+427g9UOgYY4NMSzxcwXiZfwx9P5+b7bLXmEBYM8nx7FTigGQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to debug extension update (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | 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 по дате отправления: