Re: Bad timestamp external representation

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-hackers(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bad timestamp external representation
Date: 2001-07-27 02:18:56
Message-ID: 3.0.5.32.20010727121856.030e4100@mail.rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

At 15:13 26/07/01 -0700, Nathan Myers wrote:
>Should pg_dump be lossy?

No it shouldn't, but it already is because it uses decimal text reps of
everything; we lose data when dumping floats as well. In the latter case we
should dump the hex text reps to get the full bit width. Something similar
is probably true for times etc. It's just a lot less readable.

----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 0500 83 82 82 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Samuel 2001-07-27 05:21:17 PL/PgSQL and arrays
Previous Message Martijn van Oosterhout 2001-07-27 00:49:20 Re: Re: Running Postmaster - PGDATA Variable

Browse pgsql-hackers by date

  From Date Subject
Next Message bob 2001-07-27 02:31:22 pltcl - lastoid
Previous Message Bruce Momjian 2001-07-26 23:42:54 Re: Bad timestamp external representation