| From: | Erik Wienhold <ewie(at)ewie(dot)name> |
|---|---|
| To: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Tablespace ACLs |
| Date: | 2024-10-10 16:28:37 |
| Message-ID: | 10f89717-cd7b-41a8-bde5-c0624b04f039@ewie.name |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I wrote:
> On second thought, just guarding the pg_tablespace_size() call and
> reporting an unknown size when permissions are insufficient is better,
> so that \db+ still lists all tablespaces like \db does.
And here's a patch that does that. It also adds a few words to the docs
to mention that the tablespace size is reported as NULL if the user
lacks the necessary access privileges.
I did not add a test for \db+ because the output is not stable due to
varying tablespace OIDs and owner name.
--
Erik
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-psql-call-pg_tablespace_size-if-user-has-access-p.patch | text/x-diff | 3.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Priancka Chatz | 2024-10-10 18:36:01 | Unknown temp directories and library files |
| Previous Message | Adrian Klaver | 2024-10-10 15:45:34 | Re: Connection between PostgreSQL and SAP HANA database |