Postgresql with python psycopg DataError: integer out of range

Question

I have a line of code thate give me this error: DataError: integer out of range

The line of code is this :

c.execute("INSERT INTO Users_Chat (Chat, User, Name, Id) VALUES (%s, %s, %s, %s)", (chat_version, user_id, name_user, 0, ))

I have created the table and columns with this command:

CREATE TABLE Users_Chat (Chat INT, User INT, Name TEXT, Id INT);

no, this not the problem, i tryed also without the comma and space at the end — John_python
– John_python, Commented Sep 4, 2018 at 17:35
what values do you have for chat_version, user_id, name_user? — oshaiken
– oshaiken, Commented Sep 4, 2018 at 17:41
is this inside a function and you pass those values? because postgress is expecting numbers, and probably you are passing something else. — oshaiken
– oshaiken, Commented Sep 4, 2018 at 17:41
oh, in chat_version is a number but start with a - is possible for this? I worked only with sqlite and it worked with him. Like this -1234 — John_python
– John_python, Commented Sep 4, 2018 at 17:48

oshaiken · Accepted Answer · 2018-09-04 18:00:41Z

1

c.execute("INSERT INTO Users_Chat (Chat, User, Name, Id) VALUES (%s, %s, %s, %s)", (chat_version, user_id, name_user, 0, ))

Expects only numeric/ingegers values according to doc.

Python numeric objects int, long, float, Decimal are converted into a PostgreSQL numerical representation:

answered Sep 4, 2018 at 18:00

oshaiken

2,6701 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1