Hello team ,
We  are getting ERROR:  bigint out of range. Please help on this.



ERROR:  bigint out of range
kbdb=# INSERT INTO kb_dar_ran_url_check 
(url_hash,stat_date,topic_id,site_id,url,status,user_comments,review_comments) 
VALUES 
(72894677781133866997924561390146294513,E'19-04-2019',32793,1035,E'https://bikez.com/search/index.php',1,NULL,NULL);

ERROR:  bigint out of range


Table structure is :

                    Table "kb_test.kb_dar_ran_url_check"
     Column      |          Type           | Collation | Nullable | Default
-----------------+-------------------------+-----------+----------+---------
status          | bigint                  |           |          |
url_hash        | bigint                  |           | not null |
url             | character varying(4000) |           | not null |
review_comments | character varying(4000) |           |          |
user_comments   | character varying(4000) |           |          |
stat_date       | character varying(128)  |           | not null |
topic_id        | numeric(38,0)           |           | not null |
site_id         | numeric(38,0)           |           | not null |
Partition key: LIST (stat_date)


Thanks,
Daulat

Reply via email to