Skip site navigation (1) Skip section navigation (2)

Re: Dumping/Restoring with constraints?

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "Adrian Klaver" <aklaver(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, "Andrew Sullivan" <ajs(at)commandprompt(dot)com>
Subject: Re: Dumping/Restoring with constraints?
Date: 2008-08-29 15:29:55
Message-ID: e373d31e0808290829v47d4ffe9k5fd24c7183fc19c3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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!

In response to

Responses

pgsql-admin by date

Next:From: Andrew SullivanDate: 2008-08-29 15:36:33
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Adrian KlaverDate: 2008-08-29 15:24:45
Subject: Re: Dumping/Restoring with constraints?

pgsql-general by date

Next:From: Andrew SullivanDate: 2008-08-29 15:36:33
Subject: Re: Dumping/Restoring with constraints?
Previous:From: Adrian KlaverDate: 2008-08-29 15:24:45
Subject: Re: Dumping/Restoring with constraints?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group