Kris Jurka <books (AT) ejurka (DOT) com> writes:
Thanks for catching this. It never came up before because we never
would try to output timezone info for a BC date...

We could make it output either of
0097-02-16 17:32:01 BC -08
0097-02-16 17:32:01-08 BC
as the input parser will take either. I'm kinda leaning to the latter;
any contrary opinions?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:
Maybe it's a good idea to routinely test regression dump/restore/dump
(and compare both dumps). This could also mean trying to keep the most
objects in it so features tested for regression are also tested for
recoverability ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

On Sun, Jul 11, 2004 at 09:02:06AM -0400, Bruce Momjian wrote:

This particular problem, yes, but maybe we want to detect early this
sort of problems in the future. That's why I think a dump/restore/dump
and compare both dumps could be a good test.


--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La soledad es compañía"


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend