Repository navigation
Commit c0fb063
committed
fix(postgres): give an inherited public schema back to its default owner
A database created from template1 while it was taken over inherited a
public schema owned by template1_admin. The orphaned-roles pass then
handed it to cozystack:orphaned, leaving the database owner without
CREATE on it from PostgreSQL 15 on. Releasing template1 now returns that
schema to pg_database_owner (the superuser before 15) while
template1_admin still owns it.
Assisted-by: LLM
Signed-off-by: Mattia Eleuteri <[email protected]>1 parent 482b290 commit c0fb063
2 files changed
Lines changed: 16 additions & 2 deletions
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
341 | 341 | | |
342 | 342 | | |
343 | 343 | | |
344 | | - | |
345 | | - | |
| 344 | + | |
| 345 | + | |
| 346 | + | |
346 | 347 | | |
347 | 348 | | |
348 | 349 | | |
| |||
362 | 363 | | |
363 | 364 | | |
364 | 365 | | |
| 366 | + | |
365 | 367 | | |
366 | 368 | | |
367 | 369 | | |
| |||
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
109 | 109 | | |
110 | 110 | | |
111 | 111 | | |
| 112 | + | |
| 113 | + | |
| 114 | + | |
| 115 | + | |
| 116 | + | |
| 117 | + | |
| 118 | + | |
| 119 | + | |
| 120 | + | |
| 121 | + | |
| 122 | + | |
| 123 | + | |
0 commit comments