| Lists: | Postg스포츠 토토 결과SQL |
|---|
| From: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org, pgsql-hackers-owner(at)postgresql(dot)org |
| Subject: | PostgreSQL is not behaving consistently across platforms |
| Date: | 2007-11-21 02:34:46 |
| Message-ID: | 47439946.2060709@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hello guys,
Posted this msg on general & hackers list to get most accurate responses
as possible...
I plan to use PG with an OpenCRX project... but I read that there's some
probs with PG and strings comparisons.... Is it true?
Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
Thanks
Bruno
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL is not behaving consistently across platforms |
| Date: | 2007-11-21 02:51:40 |
| Message-ID: | 21752.1195613500@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> writes:
> Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
[ shrug... ] Text sort ordering is dependent on the locale you use.
If these folk want C-locale sorting, they need to initdb in C locale.
regards, tom lane
| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL is not behaving consistently across platforms |
| Date: | 2007-11-21 08:32:50 |
| Message-ID: | 4743ED32.3080809@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg스포츠 토토 결과SQL |
Bruno Lavoie wrote:
> Hello guys,
>
> Posted this msg on general & hackers list to get most accurate responses
> as possible...
>
> I plan to use PG with an OpenCRX project... but I read that there's some
> probs with PG and strings comparisons.... Is it true?
> Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
Nothing to add to Tom's response, but it does strike me as odd that they
have a handbook in German and a localisation guide for their application
but don't know about different sort orders in different locales.
Might be worth asking on their support lists/groups about what the
underlying system understands about locales and sorting.
Oh, and if you could let them know about PG's locale handling at the
same time that would be helpful indeed.
--
Richard Huxton
Archonet Ltd
| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Bruno Lavoie <bruno(dot)lavoie(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org, pgsql-hackers-owner(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL is not behaving consistently across platforms |
| Date: | 2007-11-21 11:20:18 |
| Message-ID: | 20071121112018.GA4918@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Bruno Lavoie escribió:
> Hello guys,
>
> Posted this msg on general & hackers list to get most accurate responses as
> possible...
>
> I plan to use PG with an OpenCRX project... but I read that there's some
> probs with PG and strings comparisons.... Is it true?
> Look at: http://www.opencrx.org/opencrx/1.11/pg.htm
I find it irritating that they put such comments and not allow the
Postgres people to comment. Were we even asked about the reason for
that behavior?
Their 'installation book' also contains a couple of infelicities; namely
that they suggest using the "password" auth method (should be md5) and
that they enable the TCP/IP connection by using the "-o -i" params to
pg_ctl (should change postgresql.conf instead).
--
Alvaro Herrera http://www.flickr.com/photos/alvherre/
We take risks not to escape from life, but to prevent life escaping from us.