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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: tango ward <tangoward15(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: psycopg2.DataError: invalid input syntax for integer: ""
Date: 2018-05-07 13:12:53
Message-ID: CAKFQuwZwoQK4PXmGh5Y8CCkPgwSqZs6hKLRsg=UB=DSH3tMU4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 7, 2018 at 12:28 AM, tango ward <tangoward15(at)gmail(dot)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.
​

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-05-07 13:35:30 Re: psycopg2.DataError: invalid input syntax for integer: ""
Previous Message Igor Korot 2018-05-07 11:38:26 Re: Add schema to the query