[BUGS] Dump/Restore of cvs regression database gives invalid timestamp

#1

Dumping and restoring the regression database in cvs tip gives the
following error upon restore:

ERROR: invalid input syntax for type timestamp with time zone:
"0097-02-16 17:32:01 BC-08"
CONTEXT: COPY timestamptz_tbl, line 42, column d1: "0097-02-16 17:32:01
BC-08"

Kris Jurka

---------------------------(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)

#2

I assume this is not fixed yet, right?

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

Tom Lane wrote:

Quote:

Kris Jurka <books (AT) ejurka (DOT) 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 (AT) postgresql (DOT) org)

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#3

Bruce Momjian <pgman (AT) candle (DOT) pha.pa.us> writes:

Quote:

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

Quote:

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

Tom Lane wrote:
Kris Jurka <books (AT) ejurka (DOT) 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 (AT) postgresql (DOT) org)

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

#4

Tom just fixed this in CVS.

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

Alvaro Herrera wrote:

Quote:

On Thu, Jun 24, 2004 at 11:38:59AM -0400, Tom Lane wrote:
Kris Jurka <books (AT) ejurka (DOT) 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 (AT) postgresql (DOT) org

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) 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

---------------------------(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)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[BUGS] Dump/Restore of cvs regression database gives invalid timestamp

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

[BUGS] Dump/Restore of cvs regression database gives invalid timestamp - 06-24-2004 , 07:40 AM

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp - 07-10-2004 , 10:24 PM

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp - 07-10-2004 , 11:31 PM

Re: [BUGS] Dump/Restore of cvs regression database gives invalid timestamp - 07-11-2004 , 08:09 AM