Mo :ferris: :tux: @ FOSDEM on Nostr: bigserial has the default of auto-incrementing. So it was trying to fill the new ...
bigserial has the default of auto-incrementing. So it was trying to fill the new column with incremental values starting with 1. But there is no row with id 1 in the referrers table.
I thought that the error message is telling me that referrer_id doesn't exist in the referrers table and I went trying every other possibility to specify this constraint but the solution is to just use `bigint` instead.
Published at
2023-09-21 01:22:01Event JSON
{
"id": "ecad0b29e60cc8d78de41cc8435e9b57ffa405f2237d88c415bfd89c687914de",
"pubkey": "979383f8767c5d795fcad86f82dc7b38b384c1a473710c433014dc2c0fb0e359",
"created_at": 1695259321,
"kind": 1,
"tags": [
[
"e",
"2452c365ef596139b6e43ea8c9e957f1f734559e9b4f5a5178b7fe2cb53afc9f",
"wss://relay.mostr.pub",
"reply"
],
[
"content-warning",
"Solution"
],
[
"proxy",
"https://fosstodon.org/users/mo8it/statuses/111100514883363134",
"activitypub"
]
],
"content": "bigserial has the default of auto-incrementing. So it was trying to fill the new column with incremental values starting with 1. But there is no row with id 1 in the referrers table.\n\nI thought that the error message is telling me that referrer_id doesn't exist in the referrers table and I went trying every other possibility to specify this constraint but the solution is to just use `bigint` instead.",
"sig": "ff1f1563962711a44980d1c4f4c440716315587d1221061163cfb5b5512e7b57697023cde07dba80932f14aaade8e4df5e9d9a51f2051180290ab76b806c893b"
}
