Unix Technical Forum

Re: type money causes unrestorable dump

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-15-2008, 11:31 PM
Bruce Momjian
 
Posts: n/a
Default Re: type money causes unrestorable dump

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-15-2008, 11:31 PM
D'Arcy J.M. Cain
 
Posts: n/a
Default Re: type money causes unrestorable dump

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-15-2008, 11:31 PM
Tom Lane
 
Posts: n/a
Default Re: type money causes unrestorable dump

"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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-15-2008, 11:31 PM
D'Arcy J.M. Cain
 
Posts: n/a
Default Re: type money causes unrestorable dump

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 12:55 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com