support for DIN SPEC 91379 encoding

2022-03-27 Thread Marco Lechner
Hi, Does anyone here know, if postgresql supports DIN SPEC 91379 encoding? As far as I understand it is a “new” encoding supporting all “EU characters” based on Unicode, but is not compliant to UTF-8. As far as I di dread, there are a few characters in DIN SOEC 91379 that are not within UTF-8.

Re: support for DIN SPEC 91379 encoding

2022-03-27 Thread Ralf Schuchardt
Hi Marco, On 27 Mar 2022, at 12:54, Marco Lechner wrote: > Hi, > > Does anyone here know, if postgresql supports DIN SPEC 91379 encoding? > > As far as I understand it is a “new” encoding supporting all “EU characters” > based on Unicode, but is not compliant to UTF-8. As far as I di dread, the

Re: support for DIN SPEC 91379 encoding

2022-03-27 Thread Alvaro Herrera
On 2022-Mar-27, Ralf Schuchardt wrote: > where did you read, that this DIN SPEC 91379 norm is incompatible with UTF-8? > > In the document „String.Latin+ 1.2: eine kommentierte und erweiterte > Fassung der DIN SPEC 91379. Inklusive einer umfangreichen Liste häufig > gestellter Fragen. Herausgegeb

Re: support for DIN SPEC 91379 encoding

2022-03-27 Thread Tom Lane
Alvaro Herrera writes: > On 2022-Mar-27, Ralf Schuchardt wrote: >> linked here https://www.xoev.de/downloads-2316#StringLatin it is said, >> that the spec is a strict subset of unicode (E.1.6), and it is also >> mentioned in E.1.4, that in UTF-8 all unicode characters can be >> encoded. Therefore

Re: support for DIN SPEC 91379 encoding

2022-03-27 Thread Bzm@g
U+ is not part of DIN SPEC 91379. -- Boris > Am 27.03.2022 um 19:47 schrieb Alvaro Herrera : > > On 2022-Mar-27, Ralf Schuchardt wrote: > >> where did you read, that this DIN SPEC 91379 norm is incompatible with UTF-8? >> >> In the document „String.Latin+ 1.2: eine kommentierte und erwei

Performance issues on FK Triggers after replacing a primary column

2022-03-27 Thread Per Kaminsky
Hi there, i recently stumbled upon a performance issue which i can't really understand. The issue occured when i (roughly) did the following without a commit in between: * Replace the PK column of a table A which has a referencing table B - I have removed the FK from the referencing tables

Re: Performance issues on FK Triggers after replacing a primary column

2022-03-27 Thread Adrian Klaver
On 3/27/22 09:30, Per Kaminsky wrote: Hi there, i recently stumbled upon a performance issue which i can't really understand. The issue occured when i (roughly) did the following without a commit in between: * Replace the PK column of a table A which has a referencing table B - I have

Re: support for DIN SPEC 91379 encoding

2022-03-27 Thread Peter J. Holzer
On 2022-03-27 14:06:25 -0400, Tom Lane wrote: > Alvaro Herrera writes: > > On 2022-Mar-27, Ralf Schuchardt wrote: > >> linked here https://www.xoev.de/downloads-2316#StringLatin it is said, > >> that the spec is a strict subset of unicode (E.1.6), and it is also > >> mentioned in E.1.4, that in UT