Richard Huxton napsal(a):
I think someone is looking at per-database locales for 8.4 - the issue
is more tricky than you might think because you need to worry about
system catalogue sort-order.
There is Google Soc project for implementing collation per database level. I
hope it will appear
"Christopher Condit" <[EMAIL PROTECTED]> writes:
> Although, once you've built the index with varchar_pattern_ops index,
> the following two (essentially equivalent) queries will run at vastly
> different speeds:
> select * from A where A.value like 'Nacho';
> select * from A where A.value = 'Nacho
Seems that the optimizer should catch this...
C
-Original Message-
From: Craig Ringer [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 24, 2008 01:20
To: Christopher Condit
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] initdb in 8.3
Christopher Condit wrote:
> I have a qu
Christopher Condit wrote:
> I have a question related to this issue:
> Now that the locale has changed, it seems that the planner no longer
> wants to use the indexes for running LIKE queries on varchar columns
> unless I specify varchar_pattern_ops when creating the index. And if I
> create the in
Karsten Hilbert wrote:
On Wed, Apr 23, 2008 at 11:46:35AM +0200, Tim Tassonis wrote:
As you probably are all aware of, this results now in a cluster that
will only allow you to create UTF-8 databases. I have read some posts
regarding this topic where it is explained that allowing LATIN1 on a
m Tassonis
Sent: Wednesday, April 23, 2008 12:22
To: Martijn van Oosterhout
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] initdb in 8.3
Martijn van Oosterhout wrote:
> On Wed, Apr 23, 2008 at 04:35:04PM +0200, Tim Tassonis wrote:
>>
>> If specifying a characterset differen
On Wed, Apr 23, 2008 at 11:46:35AM +0200, Tim Tassonis wrote:
> As you probably are all aware of, this results now in a cluster that
> will only allow you to create UTF-8 databases. I have read some posts
> regarding this topic where it is explained that allowing LATIN1 on a
> cluster initia
Martijn van Oosterhout wrote:
On Wed, Apr 23, 2008 at 04:35:04PM +0200, Tim Tassonis wrote:
If specifying a characterset different from the default locale for a
database is such a bad idea, why is it possible at all?
It isn't possible, that's the point. What is possible is that client
can us
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
> If specifying a characterset different from the default locale for a
> database is such a bad idea, why is it possible at all?
Because Japanese users need this functionality. Aside from spectacularly
bizarre niche applications, that is really t
On Wed, Apr 23, 2008 at 04:35:04PM +0200, Tim Tassonis wrote:
> Ok, let me put it in another way. If UTF-8 is chosen at initdb, only
> UTF-8 databases can be created, if C is chosen, you can specify
> different encodings (UTF-8, LATIN1 etc) for each database.
>
> As I understood now, sorting wil
Peter Eisentraut wrote:
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
My question is: Why then is --locale=C not the default for initdb, as I
do regard it as a rather big annoyance that a default installation on
probably almost any modern linux distribution results in a UTF-8 only
cluster, f
Am Mittwoch, 23. April 2008 schrieb Tim Tassonis:
> My question is: Why then is --locale=C not the default for initdb, as I
> do regard it as a rather big annoyance that a default installation on
> probably almost any modern linux distribution results in a UTF-8 only
> cluster, fixable only by drop
Tim Tassonis wrote:
Hi
I just recently compiled and installed 8.3.1 on a System that has UTF-8
as the default characterset in the environment. Copied the binaries, run
initdb without parameters, the usual stuff.
As you probably are all aware of, this results now in a cluster that
will only
Hi
I just recently compiled and installed 8.3.1 on a System that has UTF-8
as the default characterset in the environment. Copied the binaries, run
initdb without parameters, the usual stuff.
As you probably are all aware of, this results now in a cluster that
will only allow you to create U
14 matches
Mail list logo
