search

RohitDhankar / DigitalCognition_OldRepo_ARCHIVED

DC is being developed to be a generic BI tool. Product preview here :- https://www.youtube.com/channel/UC9J9N9CNv15s9U9Aejpza6g/videos
2 stars 1 forks source link

psycopg2.ProgrammingError: UNION types character varying and bigint cannot be matched #10

Open RohitDhankar opened 5 years ago

RohitDhankar commented 5 years ago

psycopg2.ProgrammingError: UNION types character varying and bigint cannot be matched

issue is due to Two different PSQL Data Types “character varying” and “bigint”.

From PSQL Docs - “character varying” , is a - " character type" which has a - "variable-length with limit".

As on date not sure which Python function triggered this will keep this open and start solving from here onwards -

http://www.postgresqltutorial.com/postgresql-char-varchar-text/ https://stackoverflow.com/questions/31520629/union-type-mismatch