Postgres Pro
Downloads
Home   >   mailing lists

Postgres 15 upgrades and template1 public schema - Mailing list pgsql-general

From Bruno Wolff III
Subject Postgres 15 upgrades and template1 public schema
Date
Msg-id 20221019203602.GA6563@wolff.to
Whole thread Raw
Responses Re: Postgres 15 upgrades and template1 public schema
List pgsql-general
Tree view 
I noticed when I did an upgrade from Postgres 14 to 15 that the public 
schema in template1 was still owned by postgres instead of pg_database_owner. 
I was expecting it to change because the release notes said that new 
database clusters would have that. But shouldn't new clusters use what 
is set in template1?

pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Re: COMMIT IN STORED PROCEDURE WHILE IN A LOOP
Next
From: Ravi Krishna
Date:
Subject: Re: Speeding up adding fky on a very large table