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

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Sunday, May 6, 2018, tango ward <tangoward15(at)gmail(dot)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.
>