This is a discussion on Re: type money causes unrestorable dump within the pgsql Hackers forums, part of the PostgreSQL category; --> D'Arcy J.M. Cain wrote: > + <para> > + Since the output of this data type is locale-sensitive, it ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| D'Arcy J.M. Cain wrote: > + <para> > + Since the output of this data type is locale-sensitive, it may not > + work to load <type>money</> data into a database that has a different > + setting of <varname>lc_monetary</>. To avoid problems, before > + restoring a dump make sure <varname>lc_monetary</> has the same or > + equivalent value as in the database that was dumped. > + </para> > + How about: > + restoring a dump make sure <varname>lc_monetary</> has a value similar > + to the dumped database. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate |
| |||
| On Sun, 4 Nov 2007 17:24:10 -0500 (EST) Bruce Momjian <bruce@momjian.us> wrote: > D'Arcy J.M. Cain wrote: > > + <para> > > + Since the output of this data type is locale-sensitive, it may not > > + work to load <type>money</> data into a database that has a different > > + setting of <varname>lc_monetary</>. To avoid problems, before > > + restoring a dump make sure <varname>lc_monetary</> has the same or > > + equivalent value as in the database that was dumped. > > + </para> > > + > > How about: > > > + restoring a dump make sure <varname>lc_monetary</> has a value similar > > + to the dumped database. Hmm. I think I like Tom's version better. However, since my primary goal here is to remove the deprecation I will let you guys duke it out over the additional clause. :-) -- D'Arcy J.M. Cain <darcy@druid.net> | 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 5: don't forget to increase your free space map settings |
| |||
| "D'Arcy J.M. Cain" <darcy@druid.net> writes: > Hmm. I think I like Tom's version better. However, since my primary > goal here is to remove the deprecation I will let you guys duke it out > over the additional clause. :-) Just pick the wording you like and commit it; we've spent more than enough time on this already. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
| ||||
| On Sun, 04 Nov 2007 20:38:11 -0500 Tom Lane <tgl@sss.pgh.pa.us> wrote: > "D'Arcy J.M. Cain" <darcy@druid.net> writes: > > Hmm. I think I like Tom's version better. However, since my primary > > goal here is to remove the deprecation I will let you guys duke it out > > over the additional clause. :-) > > Just pick the wording you like and commit it; we've spent more than > enough time on this already. OK. I can't seem to connect at the moment but I will commit tomorrow morning if not before. -- D'Arcy J.M. Cain <darcy@druid.net> | 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 2: Don't 'kill -9' the postmaster |