pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedLocale example
5+ messages / 5 participants
[nested] [flat]
* Locale example
@ 2010-02-28 02:21 Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2010-02-28 02:21 UTC (permalink / raw)
To: pgsql-docs
I have updated the locale example in the manual to be more explicit with
the attached patch.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
Attachments:
/rtmp/diff (text/x-diff, 1.6K) download
Index: charset.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/charset.sgml,v
retrieving revision 2.96
diff -c -r2.96 charset.sgml
*** charset.sgml 3 Feb 2010 17:25:05 -0000 2.96
--- charset.sgml 28 Feb 2010 02:15:36 -0000
***************
*** 68,75 ****
in Sweden (<literal>SE</>). Other possibilities might be
<literal>en_US</> (U.S. English) and <literal>fr_CA</> (French
Canadian). If more than one character set can be used for a
! locale then the specifications look like this:
! <literal>cs_CZ.ISO8859-2</>. What locales are available on your
system under what names depends on what was provided by the operating
system vendor and what was installed. On most Unix systems, the command
<literal>locale -a</> will provide a list of available locales.
--- 68,82 ----
in Sweden (<literal>SE</>). Other possibilities might be
<literal>en_US</> (U.S. English) and <literal>fr_CA</> (French
Canadian). If more than one character set can be used for a
! locale then the specifications can take the form
! <replaceable>language_territory.codeset</>. For example,
! <literal>fr_BE.UTF-8</> represents the French language (fr) as
! spoken in Belgium (BE), with a <acronym>UTF-8</> character set
! encoding.
! </para>
!
! <para>
! What locales are available on your
system under what names depends on what was provided by the operating
system vendor and what was installed. On most Unix systems, the command
<literal>locale -a</> will provide a list of available locales.
* nondeterministic collations and statistics and pattern matching
@ 2020-10-06 18:59 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: PG Doc comments form @ 2020-10-06 18:59 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: morgothko@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/collation.html
Description:
If exists statistic with nondeteministic collation inherited from column
collation then using pattern matching with collation will give an error.
There is no information about it. ((
I have seen this thread
https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw...
But I can't apply this patch for some reasons.
If I knew about the problem I would not use nondeterministic collations and
choose another way.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: nondeterministic collations and statistics and pattern matching
@ 2020-10-06 20:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 5+ messages in thread
From: Tom Lane @ 2020-10-06 20:34 UTC (permalink / raw)
To: morgothko@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.org> writes:
> If exists statistic with nondeteministic collation inherited from column
> collation then using pattern matching with collation will give an error.
Yeah, that's a known problem we fixed months ago.
> There is no information about it. ((
Other than the 12.4 release note entry, you mean?
> I have seen this thread
> https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw...
> But I can't apply this patch for some reasons.
What is your point exactly? You think the documentation should
describe your unspecified reasons for not updating to 12.4?
I'm afraid I'm not a telepath.
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: nondeterministic collations and statistics and pattern matching
@ 2020-10-12 00:16 David G. Johnston <david.g.johnston@gmail.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 5+ messages in thread
From: David G. Johnston @ 2020-10-12 00:16 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: morgothko@gmail.com <morgothko@gmail.com>; pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
On Tuesday, October 6, 2020, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> PG Doc comments form <noreply@postgresql.org> writes:
> > If exists statistic with nondeteministic collation inherited from column
> > collation then using pattern matching with collation will give an error.
>
> Yeah, that's a known problem we fixed months ago.
>
> > There is no information about it. ((
>
> Other than the 12.4 release note entry, you mean?
>
> > I have seen this thread
> > https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%
> 3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw%40mail.gmail.com
> > But I can't apply this patch for some reasons.
>
> What is your point exactly? You think the documentation should
> describe your unspecified reasons for not updating to 12.4?
> I'm afraid I'm not a telepath.
>
While it doesn’t replace the need for users to look at release notes we are
generally pretty good at concluding patch threads with “applied,
back-patched to vX” comments but didn’t do that here.
David J.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: nondeterministic collations and statistics and pattern matching
@ 2020-10-12 08:49 Александр <morgothko@gmail.com>
parent: David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Александр @ 2020-10-12 08:49 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-docs@lists.postgresql.org
Yes, I checked release version and updated to 12.4.
It should have been done right away. That was my fault.
But if where was information about release in the thread of patch then
there would be no question.
пн, 12 окт. 2020 г., 3:16 David G. Johnston <david.g.johnston@gmail.com>:
> On Tuesday, October 6, 2020, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> PG Doc comments form <noreply@postgresql.org> writes:
>> > If exists statistic with nondeteministic collation inherited from column
>> > collation then using pattern matching with collation will give an error.
>>
>> Yeah, that's a known problem we fixed months ago.
>>
>> > There is no information about it. ((
>>
>> Other than the 12.4 release note entry, you mean?
>>
>> > I have seen this thread
>> >
>> https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw...
>> > But I can't apply this patch for some reasons.
>>
>> What is your point exactly? You think the documentation should
>> describe your unspecified reasons for not updating to 12.4?
>> I'm afraid I'm not a telepath.
>>
>
> While it doesn’t replace the need for users to look at release notes we
> are generally pretty good at concluding patch threads with “applied,
> back-patched to vX” comments but didn’t do that here.
>
> David J.
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2020-10-12 08:49 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-28 02:21 Locale example Bruce Momjian <bruce@momjian.us>
2020-10-06 18:59 nondeterministic collations and statistics and pattern matching PG Doc comments form <noreply@postgresql.org>
2020-10-06 20:34 ` Re: nondeterministic collations and statistics and pattern matching Tom Lane <tgl@sss.pgh.pa.us>
2020-10-12 00:16 ` Re: nondeterministic collations and statistics and pattern matching David G. Johnston <david.g.johnston@gmail.com>
2020-10-12 08:49 ` Re: nondeterministic collations and statistics and pattern matching Александр <morgothko@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox