From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Kshirsagar, Swanand *EXTERN*" <Swanand(dot)Kshirsagar(at)acs-inc(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: ERROR: invalid input syntax for type timestamp: "" |
Date: | 2012-04-20 09:06:14 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C207C34266@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Kshirsagar, Swanand wrote:
> 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.
The table definition plays an important role in this.
Could you produce a copy of the SQL file and delete everything except
for the
table in question and delete all but a few COPY input rows that
demonstrate
the problem? Send that as an attachment, then maybe we can see why it
fails.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Alexander Fortin | 2012-04-20 11:04:32 | Re: pg_database_size() and actual disk space usage |
Previous Message | videanuadrian | 2012-04-20 06:01:42 | Re: How to auto swtich the roles of primary and standby |