pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
how to check locale of a cluster? 2+ messages / 2 participants [nested] [flat]
* how to check locale of a cluster? @ 2009-02-19 00:48 Kasia Tuszynska <ktuszynska@esri.com> 0 siblings, 1 reply; 2+ messages in thread From: Kasia Tuszynska @ 2009-02-19 00:48 UTC (permalink / raw) To: pgsql-admin Hi Everybody, I am comparing selection results between postgres clusters on RHEL4 and Windows Server 2003. The query is: select count(*)from schema.table where route < 'Interstate 12' on the RHEL machine the result has: 102 records on the windows machine the result has: 586 records the entire table has 687 records On both clusters the column route is of type character varying (40) On both clusters the server encoding is UTF8 - which I can see in pgAdminIII or by querying pg_database I would like to figure out if the locale on both clusters is the same, because if the locales are different that would explain the different result sets for the same query. Does anyone know how to check the locale of a cluster? The documentation has yielded this " You can check the LC_COLLATE and LC_CTYPE settings of a database with the contrib/pg_controldata utility program." I do not have a contrib folder on either machine, I suppose that I could go install it but is there an easier way? Thank you, Sincerely, Kasia ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to check locale of a cluster? @ 2009-02-19 01:05 Tom Lane <tgl@sss.pgh.pa.us> parent: Kasia Tuszynska <ktuszynska@esri.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2009-02-19 01:05 UTC (permalink / raw) To: Kasia Tuszynska <ktuszynska@esri.com>; +Cc: pgsql-admin Kasia Tuszynska <ktuszynska@esri.com> writes: > Does anyone know how to check the locale of a cluster? "show lc_collate" has worked since 7.4. > The documentation has yielded this " You can check the LC_COLLATE and LC_CTYPE settings of a database with the contrib/pg_controldata utility program." The docs have not said that since 7.3. I really hope that is not what you are running ... especially not on the Windows machine. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2009-02-19 01:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2009-02-19 00:48 how to check locale of a cluster? Kasia Tuszynska <ktuszynska@esri.com> 2009-02-19 01:05 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox