public inbox for [email protected]help / color / mirror / Atom feed
[PATCH v25 5/5] doc: Add Collation Versions section. 6+ messages / 3 participants [nested] [flat]
* [PATCH v25 5/5] doc: Add Collation Versions section. @ 2020-03-11 02:01 Thomas Munro <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Thomas Munro @ 2020-03-11 02:01 UTC (permalink / raw) Supply a brief introduction to collation version concepts. Author: Thomas Munro Reviewed-by: Julien Rouhaud Discussion: https://postgr.es/m/CAEepm%3D0uEQCpfq_%2BLYFBdArCe4Ot98t1aR4eYiYTe%3DyavQygiQ%40mail.gmail.com --- doc/src/sgml/charset.sgml | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml index 4b4563c5b9..c537bdfc28 100644 --- a/doc/src/sgml/charset.sgml +++ b/doc/src/sgml/charset.sgml @@ -948,6 +948,41 @@ CREATE COLLATION ignore_accents (provider = icu, locale = 'und-u-ks-level1-kc-tr </tip> </sect3> </sect2> + + <sect2 id="collation-versions"> + <title>Collation Versions</title> + + <para> + The ordering defined by a collation is not necessarily fixed over time. + If a collation changes for any reason, persistent data structures such as + b-trees that depend on a stable ordering of text might be corrupted. + <productname>PostgreSQL</productname> defends against this by recording + the current version of each referenced collation for any index that + depends on it in the + <link linkend="catalog-pg-depend"><structname>pg_depend</structname></link> + catalog, if the collation provider makes it available. If the provider + later begins to report a different version, a warning will be reported + when the index is accessed, until either the <xref linkend="sql-reindex"/> + or the <xref linkend="sql-alterindex"/> command is used to update the + version. + </para> + <para> + Version information is available for collations from the + <literal>icu</literal> provider on all operating systems. For the + <literal>libc</literal> provider, versions are currently only available + on systems using the GNU C library (most Linux systems). + </para> + + <note> + <para> + When using the GNU C library for collations, the C library's version + is used as a proxy for the collation version. Many Linux distributions + change collation definitions only when upgrading the C library, but this + approach is imperfect as maintainers are free to back-port newer + collation definitions to older C library releases. + </para> + </note> + </sect2> </sect1> <sect1 id="multibyte"> -- 2.20.1 --lrZ03NoBR/3+SXJZ-- ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Trying to build x86 version on windows using meson @ 2024-03-20 22:00 Andres Freund <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Andres Freund @ 2024-03-20 22:00 UTC (permalink / raw) To: Dave Cramer <[email protected]>; +Cc: PostgreSQL Hackers <[email protected]> Hi, On 2024-03-20 17:49:14 -0400, Dave Cramer wrote: > On Wed, 20 Mar 2024 at 17:11, Andres Freund <[email protected]> wrote: > > On 2024-03-20 16:14:23 -0400, Dave Cramer wrote: > > > I am getting the following error > > > > > > meson.build:1479:17: ERROR: Can not run test applications in this cross > > > environment. > > > > > > Have configured for amd64_x86 > > > > > > Running `meson setup --wipe build --prefix=c:\postgres86` > > > > This is not enough information to debug anything. At the very least we need > > the exact steps performed to set up the build and meson-logs/meson-log.txt > > > First off this is on an ARM64 machine Uh, that's a fairly crucial bit - you're actually trying to cross compile then. I don't know much about cross compiling on windows, so it's certainly possible there's still some gaps there. > > The last error from meson-log.txt is > > ... > Checking if "c99" compiles: YES > > meson.build:1479:17: ERROR: Can not run test applications in this cross > environment. > ... That's not the meson-log.txt that you attached though? Greetings, Andres Freund ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Trying to build x86 version on windows using meson @ 2024-03-20 22:02 David Rowley <[email protected]> parent: Andres Freund <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: David Rowley @ 2024-03-20 22:02 UTC (permalink / raw) To: Andres Freund <[email protected]>; +Cc: Dave Cramer <[email protected]>; PostgreSQL Hackers <[email protected]> On Thu, 21 Mar 2024 at 11:00, Andres Freund <[email protected]> wrote: > > On 2024-03-20 17:49:14 -0400, Dave Cramer wrote: > > First off this is on an ARM64 machine > > Uh, that's a fairly crucial bit - you're actually trying to cross compile > then. I don't know much about cross compiling on windows, so it's certainly > possible there's still some gaps there. How would initdb.exe / pg_regress.exe even run on the x86 build machine if it's compiled for ARM? David ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Trying to build x86 version on windows using meson @ 2024-03-20 22:20 Andres Freund <[email protected]> parent: David Rowley <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Andres Freund @ 2024-03-20 22:20 UTC (permalink / raw) To: David Rowley <[email protected]>; +Cc: Dave Cramer <[email protected]>; PostgreSQL Hackers <[email protected]> Hi, On 2024-03-21 11:02:27 +1300, David Rowley wrote: > On Thu, 21 Mar 2024 at 11:00, Andres Freund <[email protected]> wrote: > > > > On 2024-03-20 17:49:14 -0400, Dave Cramer wrote: > > > First off this is on an ARM64 machine > > > > Uh, that's a fairly crucial bit - you're actually trying to cross compile > > then. I don't know much about cross compiling on windows, so it's certainly > > possible there's still some gaps there. > > How would initdb.exe / pg_regress.exe even run on the x86 build > machine if it's compiled for ARM? I think this is building on an ARM64 host, targeting 32bit x86. Obviously tests can't run in that environment, but building should be possible. I can e.g. build postgres for x86-64 windows on my linux machine, but can't run the tests (in theory they could be run with wine, but wine isn't complete enough to run postgres). Greetings, Andres Freund ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Trying to build x86 version on windows using meson @ 2024-07-21 12:20 Thomas Munro <[email protected]> parent: Andres Freund <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Thomas Munro @ 2024-07-21 12:20 UTC (permalink / raw) To: Andres Freund <[email protected]>; +Cc: David Rowley <[email protected]>; Dave Cramer <[email protected]>; PostgreSQL Hackers <[email protected]> On Thu, Mar 21, 2024 at 11:21 AM Andres Freund <[email protected]> wrote: > Obviously tests can't run in that environment, but building should be > possible. I can e.g. build postgres for x86-64 windows on my linux machine, > but can't run the tests (in theory they could be run with wine, but wine isn't > complete enough to run postgres). For anyone interested in that, the most apparent reason why WINE currently can't run a cross-build of psql.exe or postgres.exe on a Linux/FreeBSD/macOS host is now on their bug list[1] and just needs someone to write an easy patch. I dimly recall there were more subtle things that broke here and there before the relevant change of ours went in, and it would be pretty cool if we could make a list and report 'em... [1] https://bugs.winehq.org/show_bug.cgi?id=56951 ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Trying to build x86 version on windows using meson @ 2025-02-10 03:42 Thomas Munro <[email protected]> parent: Thomas Munro <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Thomas Munro @ 2025-02-10 03:42 UTC (permalink / raw) To: Andres Freund <[email protected]>; +Cc: David Rowley <[email protected]>; Dave Cramer <[email protected]>; PostgreSQL Hackers <[email protected]> On Mon, Jul 22, 2024 at 12:20 AM Thomas Munro <[email protected]> wrote: > On Thu, Mar 21, 2024 at 11:21 AM Andres Freund <[email protected]> wrote: > > Obviously tests can't run in that environment, but building should be > > possible. I can e.g. build postgres for x86-64 windows on my linux machine, > > but can't run the tests (in theory they could be run with wine, but wine isn't > > complete enough to run postgres). > > For anyone interested in that, the most apparent reason why WINE > currently can't run a cross-build of psql.exe or postgres.exe on a > Linux/FreeBSD/macOS host is now on their bug list[1] and just needs > someone to write an easy patch. I dimly recall there were more subtle > things that broke here and there before the relevant change of ours > went in, and it would be pretty cool if we could make a list and > report 'em... > > [1] https://bugs.winehq.org/show_bug.cgi?id=56951 Just for the record, apparently they fixed that one. ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2025-02-10 03:42 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-03-11 02:01 [PATCH v25 5/5] doc: Add Collation Versions section. Thomas Munro <[email protected]> 2024-03-20 22:00 Re: Trying to build x86 version on windows using meson Andres Freund <[email protected]> 2024-03-20 22:02 ` Re: Trying to build x86 version on windows using meson David Rowley <[email protected]> 2024-03-20 22:20 ` Re: Trying to build x86 version on windows using meson Andres Freund <[email protected]> 2024-07-21 12:20 ` Re: Trying to build x86 version on windows using meson Thomas Munro <[email protected]> 2025-02-10 03:42 ` Re: Trying to build x86 version on windows using meson Thomas Munro <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox