| From: | Don Baccus <dhogaza(at)pacifier(dot)com> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, Romanenko Mikhail <mikhail(at)angg(dot)ru>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Re: [GENERAL] Trouble with float4 afterupgrading from 6.5.3 to 7.0.2 |
| Date: | 2000-08-08 17:27:53 |
| Message-ID: | 3.0.1.32.20000808102753.01444c60@mail.pacifier.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
At 01:40 AM 8/9/00 +1000, Philip Warner wrote:
>This makes me think that some kind of binary dump in pg_dump is probably
>not a bad idea. Has anybody looked at doing a cross-platform binary COPY?
>Or some other way of representing base types - we have <type>in/out maybe
><type>exp/imp (export/import) might be useful to get a portable, lossless
>representation.
Another way to do it is to dump/restore floats in hex, maintaining the
actual binary values.
Conversion to hex, unlike conversion to decimal, is exact (16 is a power
of 2 while 10 is not, to add to your "more knowledge than you want" about
floats!)
- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philip Hallstrom | 2000-08-08 18:27:44 | AM/PM times? Am I going crazy? |
| Previous Message | Craig Anderson | 2000-08-08 15:51:23 | Postgres Authentication Problems |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Don Baccus | 2000-08-08 17:34:04 | Re: Extending to 32K row limit |
| Previous Message | Thomas Swan | 2000-08-08 17:26:37 | Re: Extending to 32K row limit |