Re: psycopg2.DataError: invalid input syntax for integer: ""

Поиск
Список
Период
Сортировка
От tango ward
Тема Re: psycopg2.DataError: invalid input syntax for integer: ""
Дата
Msg-id CAA6wQLLWBRZvnLYLHxhiV9LLfDPDFxCkt1wUZmw4-ZOwSC0nNw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psycopg2.DataError: invalid input syntax for integer: ""  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: psycopg2.DataError: invalid input syntax for integer: ""  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: psycopg2.DataError: invalid input syntax for integer: ""  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
I think I've found the culprit of the problem.

I have a field which is varchar from the source DB while on the destination DB its integer.

Reading the documentation: http://www.postgresqltutorial.com/postgresql-cast/ but it gives me error `psycopg2.DataError: invalid input syntax for integer: ""`

On Mon, May 7, 2018 at 2:39 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Sunday, May 6, 2018, tango ward <tangoward15@gmail.com> wrote:
Yes, my apologies.

May I also ask if there's a limitation for the number of timestamp with timezone fields in a table?

Not one that is likely to matter in practice.  There's a page discussing limitations on the website/docs somewhere if you wish to find out more.

David J.

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

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: CSVQL? CSV SQL? tab-separated table I/O? RENAME COLUMN
Следующее
От: "a"
Дата:
Сообщение: Is it possible to get username information while writing trigger?