Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group