This is strange because the id column is an Int and should be default autoincrementing. The error message complains about int4. If I look in the database the only int4 column is the id field. Answer It seems your users are too active, if there is more than 2.147.483.647 comment ids, the Int id has reach it max value You
Tag: cockroachdb
Group by days of a month in CockroachDB
In CockroachDB, I want to have such this query on a specific month for its every day: the problem is that I want it on my local date. What should I do? My goal is: “month, day, count, sum” as result columns for a month. UPDATE: I have found a suitable query for this purpose: Thanks to @histocrat for easier