Nicolas Martyanoff on Nostr: Today I learned that #PostgreSQL does not support row locks (FOR UPDATE) with SELECT ...
Today I learned that #PostgreSQL does not support row locks (FOR UPDATE) with SELECT DISTINCT. Not the end of the world, I can filter client side in this case, but I would love to know what led to this limitation.
Published at
2025-02-25 11:17:58Event JSON
{
"id": "886203908aa2cb526c7df8fed395aac21020b49aa3dae87244c7a8462aff74df",
"pubkey": "6d91e7b056ab18986298e04a8b278a5e070a726487fd30a599427c79db9070e9",
"created_at": 1740482278,
"kind": 1,
"tags": [
[
"t",
"postgresql"
],
[
"proxy",
"https://fosstodon.org/users/galdor/statuses/114064246589685201",
"activitypub"
]
],
"content": "Today I learned that #PostgreSQL does not support row locks (FOR UPDATE) with SELECT DISTINCT. Not the end of the world, I can filter client side in this case, but I would love to know what led to this limitation.",
"sig": "45e95d5c2d83f78e45fa05a8510d5d41f94aeb501b5f8560c0f8c15376f7068abd1aed270fe3faf7a786b4962b61d9b8ffd91dd2729c8d0f407653deedb51b93"
}
