Re: [SQL] ORDER BY collation order

2008-09-19 Thread Scott Marlowe
On Thu, Sep 18, 2008 at 10:35 PM, Joe <[EMAIL PROTECTED]> wrote: > Hi Scott, > > Scott Marlowe wrote: >> >> no, not encoding, locale, such as en_US or C determine sort order. >> > > OK, so I guess you're saying that whatever was in the LC_COLLATE environment > variable at the time the template0 dat

Re: [SQL] ORDER BY collation order

2008-09-19 Thread Petr Jelinek
Joe wrote: Thanks for the info. The hosting company already offers 8.3 databases. It's just that other things (we use tsearch2) have taken precedence over migrating to 8.3. How can I tell if the patch you mention is installed? As admin (or somebody with shell access) by running "pg_config

Re: [SQL] pg_dump in windows

2008-09-19 Thread Richard Huxton
Ramasubramanian wrote: > HI all, I am facing a problem while taking a back up in windows. It > is asking for a password while using pg_dump. Why it is asking for a > password ?(it is not asking password in linux) Give some details > about fe_sendauth in postgres . How i can avoid asking password in

[SQL] pg_dump in windows

2008-09-19 Thread Ramasubramanian
HI all, I am facing a problem while taking a back up in windows. It is asking for a password while using pg_dump. Why it is asking for a password ?(it is not asking password in linux) Give some details about fe_sendauth in postgres . How i can avoid asking password in windows shile taking bac

Re: [SQL] ORDER BY collation order

2008-09-19 Thread Petr Jelinek
Joe wrote: I guess that means the encoding of the respective template0 database is what determines the sort order (UTF8 on FreeBSD and LATIN1 on Debian), right? Unfortunately, I'm unable to change the FreeBSD cluster since it's shared with others at our hosting provider. Is there some way t