Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Different sort order
- From: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
- To: pgsql general <pgsql-general(at)postgresql(dot)org>
- Cc: Gregory Stark <stark(at)enterprisedb(dot)com>
- Subject: Re: Different sort order
- Date: Mon, 28 May 2007 20:46:22 +0200
Try on both servers: show lc_collate Unfortunately you have to initdb to set the locale. You can't set it per database or change it once it's initialized.
Right you are, but I suppose I can do a dump using pg_dumpall overwrite the cluster with initdb --locale=en_US and restore it again without the different collation giving problems ? Poul
- References:
- Different sort order
- From: Poul Møller Hansen
- Re: Different sort order
- From: Gregory Stark
- Different sort order
- Prev by Date: Re: Different sort order
- Next by Date: optimisation for a table with frequently used query
- Previous by thread: Re: Different sort order
- Next by thread: hundreds of schema vs hundreds of databases
- Indexes: