Dump/Restore of cvs regression database gives invalid timestamp syntax error

Kris Jurka <books@ejurka.com> writes:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"

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

On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:

Kris Jurka <books@ejurka.com> writes:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"

Thanks for catching this. It never came up before because we never
would try to output timezone info for a BC date...

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)

I assume this is not fixed yet, right?

---------------------------------------------------------------------------

Tom Lane wrote:

Kris Jurka <books@ejurka.com> writes:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"

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@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Bruce Momjian <pgman@candle.pha.pa.us> writes:

I assume this is not fixed yet, right?

It is not fixed, but given the lack of objections I'll go ahead and fix
it as I proposed.

regards, tom lane

Tom just fixed this in CVS.

---------------------------------------------------------------------------

Alvaro Herrera wrote:

On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:

Kris Jurka <books@ejurka.com> writes:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"

Thanks for catching this. It never came up before because we never
would try to output timezone info for a BC date...

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@postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Tom just fixed this in CVS.

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 wrote:

On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:

Kris Jurka <books@ejurka.com> writes:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"

Thanks for catching this. It never came up before because we never
would try to output timezone info for a BC date...

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>)
"La soledad es compa��a"