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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: psycopg2.DataError: invalid input syntax for integer: ""
Дата
Msg-id CAKFQuwZwoQK4PXmGh5Y8CCkPgwSqZs6hKLRsg=UB=DSH3tMU4Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: psycopg2.DataError: invalid input syntax for integer: ""  (tango ward <tangoward15@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, May 7, 2018 at 12:28 AM, tango ward <tangoward15@gmail.com> wrote:
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: ""`


You haven't asked a question and your statement is unsurprising to me.  Are you good now or do you still harbor confusion?

David J.
​

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