whey.party / rinds
A collection of Custom Bluesky Feeds, including Fresh Feeds, all under one roof
fork atom

error: nextval: reached maximum value of sequence "posts_id_seq" (2147483647) #1

open
opened by whey.party edited

id SERIAL PRIMARY KEY should probably be a bigint. rinds in production has already hit the limit after like ~a year with its current version of using ints

whey.party (author)

im not using db migrations (booo, terrible, bad) so if youre hosting this too you can do a

ALTER TABLE posts ALTER COLUMN id TYPE bigint;

ALTER SEQUENCE posts_id_seq AS bigint;
sign up or login to add to the discussion
Labels

None yet.

Participants 1
AT URI
at://did:plc:mn45tewwnse5btfftvd3powc/sh.tangled.repo.issue/3m5ajnw2bef22