Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid input syntax for type timestamp: ""

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 (view raw or flat)
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

In response to

pgsql-admin by date

Next:From: Alexander FortinDate: 2012-04-20 11:04:32
Subject: Re: pg_database_size() and actual disk space usage
Previous:From: videanuadrianDate: 2012-04-20 06:01:42
Subject: Re: How to auto swtich the roles of primary and standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group