Re: [GENERAL] Floating point error

2013-03-02 Thread James Cloos
> "TD" == Tom Duffey writes: TD> We have a script thatb uses COPY to transfer a subset of rows TD> from a very large production table to a test table. The script TD> was not setting extra_float_digits so the values did not match TD> even though they appeared to match when running queries in p

Re: [GENERAL] broke postgres, how to fix??

2013-03-02 Thread JD Wong
Thank you everybody for your help, This problem has been resolved, in part to your insights. All the best, -JD On Fri, Mar 1, 2013 at 4:31 AM, Albe Laurenz wrote: > JD Wong wrote: > >>> Hi Adrian, yes I completely copied the config-file and data directories > >>> over. > > >> That's guaran