Re: [GENERAL] PostgreSQL is not behaving consistently across platforms
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. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [GENERAL] PostgreSQL is not behaving consistently across platforms
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] PostgreSQL is not behaving consistently across platforms
Bruno Lavoie <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[GENERAL] PostgreSQL is not behaving consistently across platforms
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/