"Stephen Denne" <[EMAIL PROTECTED]> writes:
> i.e. Do I still have to either initdb --locale=C or explicitly use
> text_pattern_ops?
yes, if you want an index to be used
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's PostGIS support!
-
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> Just set down the branch so that movement can happen towards 8.4.0 ... let me
> know if there are any problems ...
Looks good from here --- I stamped HEAD as 8.4devel.
Let the games begin!
regards, tom lane
---
Given the improvements in 8.3 listed in the release notes:
- Improve efficiency of LIKE/ILIKE, especially for multi-byte character sets
like UTF-8 (Andrew, Itagaki Takahiro)
Does this still hold:
http://www.postgresql.org/docs/8.3/interactive/locale.html
"The drawback of using locales other than
We have branced CVS for 8.4. The 8.3 CVS tag is REL8_3_STABLE.
I have started tracking our development status at the top of my
Postgres blog page.
--
Bruce Momjian <[EMAIL PROTECTED]>http://momjian.us
EnterpriseDB http://postgres.enterprisedb.com
+ I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Just set down the branch so that movement can happen towards 8.4.0 ... let me
know if there are any problems ...
-
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email . [EMAIL PROTECTED]
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> Gregory Stark wrote:
>> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>>
>> > For the patches lists I need to take sometimes entire threads, sometimes
>> > groups of comments, and store them in a format so people can review them
>> > as a digest.
>>
Gregory Stark wrote:
> "Bruce Momjian" <[EMAIL PROTECTED]> writes:
>
> > Suppose we were using a web-based discussion forum, rather than email.
>
> That would be crazy, why would I suppose such a thing?
>
> > For the patches lists I need to take sometimes entire threads, sometimes
> > groups of
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> Suppose we were using a web-based discussion forum, rather than email.
That would be crazy, why would I suppose such a thing?
> For the patches lists I need to take sometimes entire threads, sometimes
> groups of comments, and store them in a format
From: "Alvaro Herrera" <[EMAIL PROTECTED]>
Dave Page wrote:
On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> What this really means is that locale support is completely broken in
> the MSVC build, i.e. you cannot get localized strings at all (not just
> to_char()). Is this
Hi Alvaro-san.
Yes, However, It is not in good condition at the reason a message catalog still is not enough.
Then, I have tried these adjustments with the problem of a locale. Still, it is not much time.
But, My condition is not good so that I'm may be influenza. :-(
Regards,
Hiroshi Saito
Brendan Jurd wrote:
> On Feb 13, 2008 10:45 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > For the patches lists I need to take sometimes entire threads, sometimes
> > groups of comments, and store them in a format so people can review them
> > as a digest. And I want to allow comments on these
On Feb 13, 2008 10:45 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> For the patches lists I need to take sometimes entire threads, sometimes
> groups of comments, and store them in a format so people can review them
> as a digest. And I want to allow comments on these items, and ideally
> allow m
Bruce Momjian wrote:
> Bruce Momjian wrote:
> > Bruce Momjian wrote:
> > > Tom Lane wrote:
> > > > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > > > I have added message-id's to both patches web sites. The message id
> > > > > appears next to the author in the thread listing, and at the top of
> What this really means is that locale support is completely
> broken in the MSVC build, i.e. you cannot get localized
> strings at all (not just to_char()). Is this correct? If
> so, this is a serious problem.
>
The way one could confirm this is by:
1. rename share/locale/de to share/loca
Bruce Momjian wrote:
> Bruce Momjian wrote:
> > Tom Lane wrote:
> > > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > > I have added message-id's to both patches web sites. The message id
> > > > appears next to the author in the thread listing, and at the top of the
> > > > message page.
> > >
>
Bruce Momjian wrote:
> Tom Lane wrote:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > I have added message-id's to both patches web sites. The message id
> > > appears next to the author in the thread listing, and at the top of the
> > > message page.
> >
> > That's an improvement, but it do
Alvaro Herrera wrote:
Gevik Babakhani wrote:
4. Locale names are different in MS Windows. I created a C app to test
gettext on Windows.
setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and
de_DE do not :(
SET LC_MESSAGES to '' has no effect because:
A. gettext com
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I have added message-id's to both patches web sites. The message id
> > appears next to the author in the thread listing, and at the top of the
> > message page.
>
> That's an improvement, but it doesn't solve the other fundamental
>
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I have added message-id's to both patches web sites. The message id
> appears next to the author in the thread listing, and at the top of the
> message page.
That's an improvement, but it doesn't solve the other fundamental
problem, which is the lack of
Joshua D. Drake wrote:
What the heck is a steam hammer? :P
http://en.wikipedia.org/wiki/Steam_hammer
The same people went on to invent the steam television ...
cheers
andrew
---(end of broadcast)---
TIP 2: Don't 'kill -9' the post
Stefan Kaltenbrunner wrote:
> Stefan Kaltenbrunner wrote:
> > Tom Lane wrote:
> [...]
> >> Personally I'd be happier with an editable wiki page consisting of links
> >> to the original messages in the mail list archives, plus free-format
> >> annotations (such as status). This should be trivial to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 11 Feb 2008 17:09:45 -0600
Decibel! <[EMAIL PROTECTED]> wrote:
> On Feb 9, 2008, at 1:08 AM, Tom Lane wrote:
> > Let's not swat flies with steam hammers.
>
>
> What the heck is a steam hammer? :P
http://en.wikipedia.org/wiki/Steam_hammer
J
Dave Page wrote:
> On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> > What this really means is that locale support is completely broken in
> > the MSVC build, i.e. you cannot get localized strings at all (not just
> > to_char()). Is this correct? If so, this is a serious prob
On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> What this really means is that locale support is completely broken in
> the MSVC build, i.e. you cannot get localized strings at all (not just
> to_char()). Is this correct? If so, this is a serious problem.
Not judging by Hiro
Gevik Babakhani wrote:
> 4. Locale names are different in MS Windows. I created a C app to test
> gettext on Windows.
> setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and
> de_DE do not :(
>
> SET LC_MESSAGES to '' has no effect because:
>
> A. gettext compiled/link
> to_char's month/day name localization is implemented with
> gettext() not strftime(), which is why it depends on
> LC_MESSAGES not LC_TIME. I seem to recall that we didn't
> like the side-effects of the patch you are mentioning, and so
> it ended up being rejected outright.
Correct. I have
Hiroshi Saito wrote:
> Hi
>
> --Document.--
> Table 9-22.
> TM prefix translation mode (print localized day and month names based on
> lc_messages)
> --
> http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png
> But, Although Japanese is out of condition
>
> Does the fundamental specification chang
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> On Nov 24 2006 this was committed dor src/backend/utils/adt/formatting.c:
> r 1.114: Fix to_char() locale handling to honor LC_TIME, not LC_MESSAGES.
> A few hours later it was supposedly reverted: r 1.115: Revert (too late
> in beta): Fix to_char() l
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> I find it a bit worrying that the postmaster is calling that syscall at
> all.
Yeah. Misguided thread-aware library perhaps?
Next time please try to get a stack trace.
regards, tom lane
---(end of broa
Andrew Dunstan wrote:
>
>
> Alvaro Herrera wrote:
> > Gevik Babakhani wrote:
> >
> >> I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
> >> support is broke.
> >> Could someone please confirm this.
> >>
> >
> > What I can confirm is that lc_messages is supposed t
Hi
--Document.--
Table 9-22.
TM prefix translation mode (print localized day and month names based on
lc_messages)
--
http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png
But, Although Japanese is out of condition
Does the fundamental specification change?
Regards,
Hiroshi Saito
- Origin
Dan Langille wrote:
> Looking at ktrace output, I saw a lot of this:
>
> 1172 postgres CALL kse_release(0xbfbfd500)
> 1172 postgres RET kse_release -1 errno 22 Invalid argument
Humm, kse_release seems related to multithreading. Or so says
http://nixdoc.net/man-pages/FreeBSD/kse_release.2.html
Folks,
I encountered a situation on Sunday night where the postmaster was in
a tight
loop. That's the conclusion we reached, but have no real proof. I
also have no
idea how to reproduce this situation. This post is just an FYI in
case it helps.
The laptop was running hot so I looked ar
Alvaro Herrera wrote:
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
What I can confirm is that lc_messages is supposed to work for to_char,
because it shows the localized output f
Gevik Babakhani wrote:
> I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
> support is broke.
> Could someone please confirm this.
What I can confirm is that lc_messages is supposed to work for to_char,
because it shows the localized output for me as I change lc_messages;
> Right, I know that. But I didn't see you trying lc_time as
> Andrew suggested.
>
Did that too, but no luck :(
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Gevik Babakhani wrote:
Well, that should be considered a bug, not a feature.
Perhaps it was fixed in 8.3.
This is 8.3 I am testing with.
You are missing Alvaro's point. He is saying that the behaviour you
relied on in 8.2.6 was a bug, and possibly you can no longer rely on th
Gevik Babakhani wrote:
> > Well, that should be considered a bug, not a feature.
> > Perhaps it was fixed in 8.3.
>
> This is 8.3 I am testing with.
Right, I know that. But I didn't see you trying lc_time as Andrew
suggested.
--
Alvaro Herrerahttp://www.Comman
> Well, that should be considered a bug, not a feature.
> Perhaps it was fixed in 8.3.
>
This is 8.3 I am testing with.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Gevik Babakhani wrote:
> > Should that not be lc_time you are setting? lc_messages is
> > for, uh, messages.
>
> No. The same thing works on 8.2.6
Well, that should be considered a bug, not a feature. Perhaps it was
fixed in 8.3.
--
Alvaro Herrerahttp://www.Com
> Should that not be lc_time you are setting? lc_messages is
> for, uh, messages.
No. The same thing works on 8.2.6
---(end of broadcast)---
TIP 6: explain analyze is your friend
Gevik Babakhani wrote:
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
My test:
Gevik=#
Gevik=# set lc_messages TO 'de_DE.utf8';
SET
Gevik=# show lc_messages ;
lc_messages
-
de_DE.utf8
(1 row)
Gevi
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS
support is broke.
Could someone please confirm this.
My test:
Gevik=#
Gevik=# show lc_messages ;
lc_messages
English_United States.1252
(1 row)
Gevik=#
Gevik=# set lc_messages TO 'de_
Martijn van Oosterhout wrote:
On Tue, Feb 12, 2008 at 05:49:12AM -0500, Bruce Momjian wrote:
There is no reason I have to host the list here. I can _bounce_ emails
to any address. Is there a service we can use that allows emails to be
accepted and displayed on a web site and that allows deleti
Gregory Stark wrote:
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
If we want to communicate via a web interface, I would still need a way
to collect specific messages (not always entire threads).
You're talking about collecting messages. Everyone else wants to collect
patches or proposed chang
"Bruce Momjian" <[EMAIL PROTECTED]> writes:
> If we want to communicate via a web interface, I would still need a way
> to collect specific messages (not always entire threads).
You're talking about collecting messages. Everyone else wants to collect
patches or proposed changes. There's not a one
On Tue, Feb 12, 2008 at 05:49:12AM -0500, Bruce Momjian wrote:
> There is no reason I have to host the list here. I can _bounce_ emails
> to any address. Is there a service we can use that allows emails to be
> accepted and displayed on a web site and that allows deletions and
> comments, and has
Magnus Hagander wrote:
> It would also be better to be able to off-load it to more than one
> person. For example, I would like to be able to get into the unapplied
> patches list and remove the email about events on 8.3RC1. First of all,
> it's not a patch, but it's listed under it. But more im
Hi Greg,
So I had a thought about how to soften the controversial hard cutoff of 100
for the use of the histogram selectivity. Instead of switching 100% one way or
the other between the two heuristics why not calculate both and combine them.
The larger the sample size from the histogram the more
49 matches
Mail list logo
