From: | "Kshirsagar, Swanand" <Swanand(dot)Kshirsagar(at)acs-inc(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | ERROR: invalid input syntax for type timestamp: "" |
Date: | 2012-04-19 10:23:01 |
Message-ID: | 629759FB93FA0A418C04A7E53DB3B473083F2FA3@A1DAL1SWPES17MB.ams.acs-inc.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello,
I am using Postgres version 8.3.17 on one of my database server. I have
received a .sql dump file from my client. Which is supposed to be taken
from a Postgres 8.3.7 db. Now, I have created an empty database and I am
trying to restore the .sql file with command psql command. After few GBs
of restoration, I am getting an error -
ALTER TABLE
SET
SET
ERROR: invalid input syntax for type timestamp: ""
CONTEXT: COPY job_step_history, line 16211941, column start_time: ""
I tried printing this line no - 16211941 from the .sql dump file with
command - sed -n "16211941 p" <filename.sql> . The row has values -
17338525 1 309 6 205636 2009-09-04 22:02:46.199
1 2009-09-04 22:02:46.198 1 \N
What can be the possible cause for this error? Please help.
Regards,
Swanand
From | Date | Subject | |
---|---|---|---|
Next Message | videanuadrian | 2012-04-19 10:47:26 | Re: How to auto swtich the roles of primary and standby |
Previous Message | Albe Laurenz | 2012-04-19 08:24:14 | Re: invalid byte sequence for encoding "UTF8": 0xf481 - how could this happen? |