| From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | bigint out of range |
| Date: | 2019-05-16 15:31:00 |
| Message-ID: | BL0PR01MB518741644F902D8F4E447FF99B0A0@BL0PR01MB5187.prod.exchangelabs.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoff Winkless | 2019-05-16 15:42:01 | Re: bigint out of range |
| Previous Message | Adrian Klaver | 2019-05-16 15:03:21 | Re: Returning empty on insert |