jackc / jackc/pgx

Cann't save uint64 , error: "value is greater than maximum value for Int4"

Open
#1,051 10 comments 1 reaction 0 assignees View on GitHub
Dominant language
Go
Stars
14.3k
Forks
1.1k
Avg merge
6d 9h
Merged PRs (30d)
11

Description

Hi,
I want to save the value of a uint64 variable in a table, the target column type is "BIGINT", but I get the error "868957043361742 is greater than maximum value for Int4"
I have no error when I save this value directly in the table.
I used pgxpool.Pool to connect to the database

Contributor guide

Open the contributing guide

Research direction

Start at the pgxpool.Pool parameter handling and reproduce saving uint64 value 868957043361742 into a PostgreSQL BIGINT column. Trace why the value is treated as Int4; done when the value saves successfully without the maximum-value error and the behavior is covered by a regression test.

Written by the indexing model from the issue text.

Assessment

Tech stack
go, postgresql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.