bigint out of range - Mailing list pgsql-general

From Daulat Ram
Subject bigint out of range
Date
Msg-id BL0PR01MB518741644F902D8F4E447FF99B0A0@BL0PR01MB5187.prod.exchangelabs.com
Whole thread Raw
Responses Re: bigint out of range
Re: bigint out of range
Re: bigint out of range
List 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Returning empty on insert
Next
From: Geoff Winkless
Date:
Subject: Re: bigint out of range