I set the locale to hi_IN during initdb. pg_controldata and show lc_collate both show that locale is hi_IN. But postgresql is not returning sorted records. What can I do next to get sorting working on postgresql? --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > Hitesh Bagadiya <bagadiya@yahoo.com> writes: > > We did set the locate to hi_IN at initdb but sorting is not > > working. > > You should check that you have selected a database encoding > that matches > what the locale expects. Also double-check that you really do > have that > locale selected (use pg_controldata, or in 7.4 just "show > lc_collate"). > > regards, tom lane > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster __________________________________ Do you Yahoo!? Yahoo! Tax Center - File online by April 15th http://taxes.yahoo.com/filing.html ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
