Date: Tue, 18 Jun 2024 15:32:55 +0200
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: pgsql-general@lists.postgresql.org
Subject: Re: DROP COLLATION vs pg_collation question
Message-ID: <ZnGMh-MkQ6aG5tF2@hermes.hilbert.loc>
References: <Zmi-gljgKdjQmY8B@hermes.hilbert.loc>
 <d3384b9f1e870eda5f6a01b008209398b18b36d4.camel@cybertec.at>
 <ZmnzY3uqoiBrFOoO@hermes.hilbert.loc>
 <26f717988471c4d672cce8c495a2c8e68446486a.camel@cybertec.at>
 <ZmyjJA0jGU5TL64I@hermes.hilbert.loc>
 <56da532b44bc02a7648796041ffa5da0a85c06df.camel@cybertec.at>
 <Zm6wB76XFH2Za1SC@hermes.hilbert.loc>
 <740fb9086af71f864ddb526cad1e55888385bedd.camel@cybertec.at>
 <3031360.1718570329@sss.pgh.pa.us>
 <ZnGFgH9oKiynIbY6@hermes.hilbert.loc>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <ZnGFgH9oKiynIbY6@hermes.hilbert.loc>
Ma_X_il-Followup-to: d
Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net
Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net
X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net
X-Pri_X_ority: 2 (High)
Sender: <karsten.hilbert@gmx.net>
X-Provags-ID: V03:K1:35JCccMDBWzwRscEzEVZb1vrm9WsZlAoAF2G9FFxxkAdeDvYb5u
 mtE6CJRBeESLt11yS7/ake5eKRe+kXvLEiEapPP+L5cVSXuu5yzCeGLa1rKFx33jWGwkKjD
 x24jeMErBaFdE3TQSeZ7cxhrpKNbHHBbUmevhQTpfFRVc7X8vkWiNw4dKENj9Ou0z/7pFXf
 GsTCzVNJ8jqYYUD1RnGYQ==
X-Spam-Flag: NO
UI-OutboundReport: notjunk:1;M01:P0:zXeH9gzDJnw=;2Wqd3iWdtWX8mKheLlqWO5WEXzH
 PpCfWcAWPREoRBT5RJmyIIBA7qEWrGTtyuw+kMdE3E0Vte9l/0N1Hj6fcL+D6vUND0xMzdy72
 qIx//SZ5WlMia42iuw16uoL6vAtfSD5/P46t8dSummLbn2PuUYnw2IMvA8+etm9A9fuK4Z42j
 pdXy5WOLCtZphWOwi2sJkIzbXearZTCAuI1LN8LlOUb+6jU92QOpT/X+qZNHJ0FJSk2ZxY5Wb
 sFIYJXnvoCGC1xZ+Ogiy8vFATlYifeGuHgbgwmbgo6iqPfTy+MlVOV8hJxBJWUotmF3DJ+x55
 JqPHkT1O2Bx3rATSP6T6DvC2/ESGcVsavv/r4269lCLnl2zwEjx99R8H7qdABxtsa3MZigpZR
 56tfioRJdKlpKCpeJFDIX+1SQpYfqtw4aFaAItaROmFZap1pH9MM5DVLV38W1VTrI3RjG8kSt
 AZb3Xw9LorHtOEFCtVjGGzjGPqBpN8ZUa7DSd7L4FHpc5BYqm2dRm1IhvdtxIQng500wIsxMU
 1S4GNmXXaj2DadvhL5feW4+XdLCVAXqDESSlsdyqHjwGcFAm9X+mMoW7KW+L/gNBauxymJlNX
 TTDmpF5bTrYNEg5m+anj2dVql8Kd+z3kqVJF7A2PRV86Do3oJcyjUKjV+Vh3vkRbjUA/tHhyH
 CwaEIbSZSLpPwR1JcLp2xv7rQp6k+zYIoS8AqwmMhlf7zhWUyHYBQyiwZZgQ/RYbS2F6Wat84
 BdRjBaCjcPm3fJSeWu61O2hxXebU33U9tCnHZZagtD43i8mwV7MNV62z6inipOGnmLO+61ESn
 0m04PoqCQsLxoZV/n50tzG3UZVcHDwX9G/Ncbl3b8lzLc=
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/ZnGMh-MkQ6aG5tF2%40hermes.hilbert.loc>
Precedence: bulk

Am Tue, Jun 18, 2024 at 03:02:56PM +0200 schrieb Karsten Hilbert:

> I see, and since any database can be used as a template for
> more databases, which can be create with an encoding
> different from the template,

Proving myself wrong:


root@hermes:~/tmp# sudo -u postgres psql -e -f /tmp/db.sql
Output format is wrapped.
drop database if exists new_tmpl;
DROP DATABASE
create database new_tmpl with encoding =3D 'utf8';
CREATE DATABASE
You are now connected to database "new_tmpl" as user "postgres".
select current_database();
 current_database
=2D-----------------
 new_tmpl
(1 row)

drop database if exists new_latin1;
psql:/tmp/db.sql:8: HINWEIS:  Datenbank =BBnew_latin1=AB existiert nicht, =
wird =FCbersprungen
DROP DATABASE
create database new_latin1 with template =3D new_tmpl encoding =3D 'latin1=
' locale =3D 'de_DE@latin1';
psql:/tmp/db.sql:9: FEHLER:  neue Kodierung (LATIN1) ist inkompatibel mit =
der Kodierung der Template-Datenbank (UTF8)
TIP:  Verwenden Sie die gleiche Kodierung wie die Template-Datenbank oder =
verwenden Sie template0 als Template.

Karsten
=2D-
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B