PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID16025
PG Version11.5
OSUbuntu 18.04 LTS
Opened2019-09-25 23:31:42+00
Reported byMatthew Kingsbury

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      16025
Logged by:          Matthew Kingsbury
Email address:      (redacted)
PostgreSQL version: 11.5
Operating system:   Ubuntu 18.04 LTS

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:

  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.


2019-09-25 23:31:42+00PG Bug reporting formBUG #16025: pg_default tablespace is removable but not creatable
2019-09-26 00:09:21+00Tom LaneRe: BUG #16025: pg_default tablespace is removable but not creatable