Alvaro Herrera wrote:
> LC_COLLATE=pt_PT sort << EOF
> GABRIEL ALEXANDRE DA SILVA MANICA
> GABRIELA JACOBY NOS
> GABRIELA HELEDA DE SOUZA
> GABRIELA LETICIA BATISTA NUNES
> GABRIEL ALCIDES KLIM PERONDI
> EOF
>
> On my system it outputs the order you show above, which shows that my
> locale is corre
"Tomeh, Husam" <[EMAIL PROTECTED]> writes:
> I'm getting the following errors on one of my pg server running postgres
> 7.4.5 on RedHat AS R4.
> LOG: could not receive data from client: Connection reset by peer
> LOG: incomplete startup packet
> What I found out is that there's a networking VIP
I'm getting the following errors on one of my pg server running postgres
7.4.5 on RedHat AS R4.
LOG: could not receive data from client: Connection reset by peer
LOG: incomplete startup packet
What I found out is that there's a networking VIP monitoring port 5432
every 15 sec and that's basic
Erika Terahata Torres Prada e Silva - MPS wrote:
>
> Thanks everybody.
>
>
> The correct order in Portuguese would return as brazilian telephone guide
> order as below:
>
> select * from aluno order by nome
> id nome
> 38 GABRIEL ALCIDES KLIM PERONDI
> 40 GABRI
Thanks everybody.
The correct order in Portuguese would return as brazilian telephone guide
order as below:
select * from aluno order by nome
id nome
38 GABRIEL ALCIDES KLIM PERONDI
40 GABRIEL ALEXANDRE DA SILVA MANICA
36 GABRIELA HELEDA DE S
[EMAIL PROTECTED] wrote:
> These are both logged as ERROR: which is easy to check for with
> automatic monitoring. However I wouldn't want to be called out to fix
> a non-existent error where someone has typed in some nonsense. Is it
> easy to suppress the syntax errors so that the real database er
Erika Terahata Torres Prada e Silva - MPS wrote:
> But it's not correct to my language pt_BR and it worked correctly
> with PostgreSQL at Windows and FreeBSD. I have this problem only with
> Debian and now I'm looking for some Debian related issue.
String ordering is determined by national and int
Thanks.
**
Nota: La informacion transmitida a traves de este correo electronico es
confidencial y esta dirigida unicamente a su destinatario. Su reproduccion,
lectura o uso esta prohibido a cualquier persona o ent
Erika Terahata Torres Prada e Silva - MPS wrote:
> Peter,
>
> Thanks for answering.
>
> But it's not correct to my language pt_BR and it worked correctly with
> PostgreSQL at Windows and FreeBSD. I have this problem only with Debian and
> now I'm looking for some Debian related issue.
It's stil
On Thu, 2006-08-17 at 08:33, [EMAIL PROTECTED] wrote:
> I am testing the monitoring of the postgresql 8.1.4 - I have found
> that I would like to suppress some things from the log
>
> For example if I type some random rubbish into the database instead of
> select…. I get an error message logged in
I just experienced this. I changed the collating sequence to POSIX
and sorting worked as I had expected.
To change the collating sequence you will have to backup the database,
issue initdb with the --lc-collate=POSIX and then restore the data. In
my case, the encoding is still UTF8.
Paul
Peter,
Thanks for answering.
But it's not correct to my language pt_BR and it worked correctly with
PostgreSQL at Windows and FreeBSD. I have this problem only with Debian and
now I'm looking for some Debian related issue.
-Mensagem original-
De: Peter Eisentraut [mailto:[EMAIL PROTEC
Title: Monitoring error messages
I am testing the monitoring of the postgresql 8.1.4 - I have found that I would like to suppress some things from the log
For example if I type some random rubbish into the database instead of select…. I get an error message logged into the server logfile lik
Erika Terahata Torres Prada e Silva - MPS wrote:
> I'm having the following issue:
>
> create table aluno (id serial, nome varchar(60));
>
> rodrigo=# select * from aluno order by nome offset 35 limit 5;
> id | nome
> +---
> 36 | GABRIELA HELEDA D
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
15 matches
Mail list logo
