BUG #19097: System catalog modifications are allowed by alter - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #19097: System catalog modifications are allowed by alter
Date
Msg-id 19097-bfe65aa1043dba27@postgresql.org
Whole thread Raw
Responses Re: BUG #19097: System catalog modifications are allowed by alter
Re: BUG #19097: System catalog modifications are allowed by alter
Re: BUG #19097: System catalog modifications are allowed by alter
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      19097
Logged by:          RekGRpth
Email address:      rekgrpth@gmail.com
PostgreSQL version: 18.0
Operating system:   docker alpine
Description:

```sql
create table pg_catalog.t (i int);
ERROR:  permission denied to create "pg_catalog.t"
DETAIL:  System catalog modifications are currently disallowed.

create table t (i int);
CREATE TABLE

alter table t set schema pg_catalog;
ALTER TABLE

\dS+ t
                                          Table "pg_catalog.t"
 Column |  Type   | Collation | Nullable | Default | Storage | Compression |
Stats target | Description
--------+---------+-----------+----------+---------+---------+-------------+--------------+-------------
 i      | integer |           |          |         | plain   |             |
|
Replica Identity: NOTHING
Access method: heap

drop table pg_catalog.t;
DROP TABLE
```


pgsql-bugs by date:

Previous
From: Richard Guo
Date:
Subject: Re: [EXTERNAL]Re: BUG #19094: select statement on postgres 17 vs postgres 18 is returning different/duplicate results
Next
From: Michael Paquier
Date:
Subject: Re: BUG #19093: Behavioral change in walreceiver termination between PostgreSQL 14.17 and 14.18