| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | kingsbury(dot)matthew(at)gmail(dot)com |
| Subject: | BUG #16025: pg_default tablespace is removable but not creatable |
| Date: | 2019-09-25 23:31:42 |
| Message-ID: | 16025-c86354bc1ad3e898@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 16025
Logged by: Matthew Kingsbury
Email address: kingsbury(dot)matthew(at)gmail(dot)com
PostgreSQL version: 11.5
Operating system: Ubuntu 18.04 LTS
Description:
I was able to rename pg_default to something else, accidentally. However,
there appears to be no mechanism to replace pg_default nor can one replace
the pg_default after performing this action. E.g. if one runs the command:
ALTER TABLESPACE pg_default
RENAME TO not_pg_default;
ALTER TABLESPACE not_pg_default
RENAME TO pg_default;
One encounters this error:
ERROR: unacceptable tablespace name "pg_default"
DETAIL: The prefix "pg_" is reserved for system tablespaces.
Leaving one without the pg_default tablespace.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2019-09-26 00:09:21 | Re: BUG #16025: pg_default tablespace is removable but not creatable |
| Previous Message | Stephan Knauss | 2019-09-25 23:21:49 | Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres |