ERROR: invalid input syntax for type timestamp: ""

Поиск
Список
Период
Сортировка
От Kshirsagar, Swanand
Тема ERROR: invalid input syntax for type timestamp: ""
Дата
Msg-id 629759FB93FA0A418C04A7E53DB3B473083F2FA3@A1DAL1SWPES17MB.ams.acs-inc.net
обсуждение исходный текст
Ответы Re: ERROR: invalid input syntax for type timestamp: ""
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: videanuadrian
Дата:
Сообщение: Re: How to auto swtich the roles of primary and standby
Следующее
От: jenopob
Дата:
Сообщение: Re: How to auto swtich the roles of primary and standby