On Tue, 9 Oct 2007 19:02:38 +0200 Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Dienstag, 9. Oktober 2007 schrieb D'Arcy J.M. Cain: > > + Due to locale changes this type may have problems with dump and > > + restore and care should be taken. > > With respect, this kind of advice is useless. What are the problems, when do > they occur, and what should be done about them? We do know the answers to > all of these questions.
Right. How about this: ... restore and care should be taken when dumping and reloading from different locales. To avoid problems always explicitely set your locale before both a dump and reload and make sure that they are identical. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate