From: Phoenix Kiula <phoenix.kiula@gmail.com>
To: Adrian Klaver <aklaver@comcast.net>
Cc: pgsql-general@postgresql.org, "Andrew Sullivan" <ajs@commandprompt.com>
Subject: Re: Dumping/Restoring with constraints?
Date: Fri, 29 Aug 2008 23:29:55 +0800
Message-ID: <e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com> (raw)
In-Reply-To: <200808290824.45721.aklaver@comcast.net>
References: <e373d31e0808270619uba31c8eodc2c85662b85140a@mail.gmail.com>
<20080829144924.GD29678@commandprompt.com>
<e373d31e0808290812j796855e5lf3b92eeb1fde8c5f@mail.gmail.com>
<200808290824.45721.aklaver@comcast.net>
Thanks so much! I think we may be on to something:
On the pg_dump machine:
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
On the pg_restore machine:
LANG=
LC_COLLATE="C"
LC_CTYPE="UTF-8"
LC_MESSAGES="C"
LC_MONETARY="C"
LC_NUMERIC="C"
LC_TIME="C"
LC_ALL=
So how can I change the locale on my local OSX machine? This could be
it. Thanks!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: phoenix.kiula@gmail.com, aklaver@comcast.net, ajs@commandprompt.com
Subject: Re: Dumping/Restoring with constraints?
In-Reply-To: <e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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