{"url":"https://tech-book.precena.co.jp/entry/software/backend/db/acquiring_lock_for_deletion_row_postgres","type":"rich","author_name":"precena_engineer","version":"1.0","title":"PostgreSQL\u306b\u304a\u3051\u308b\u3001\u524a\u9664\u884c\u306b\u5bfe\u3059\u308b\u30ed\u30c3\u30af\u7372\u5f97\u6642\u306e\u6319\u52d5","height":"190","width":"100%","categories":["\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u958b\u767a","\u30d0\u30c3\u30af\u30a8\u30f3\u30c9","DB"],"published":"2025-02-21 13:28:43","provider_url":"https://hatena.blog","description":"\u74b0\u5883 RDB PostgreSQL 13.3 \u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5206\u96e2\u30ec\u30d9\u30eb read committed (\u30c7\u30d5\u30a9\u30eb\u30c8) \u5b9f\u9a13\u74b0\u5883 IntelliJ IDEA 2024.3 (Ultimate Edition) TLDR PostgreSQL\u306b\u304a\u3044\u3066\u3001\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u5185\u3067\u540c\u4e00\u30ad\u30fc\u306e\u884c\u3092 delete - insert \u3059\u308b\u5834\u5408\u3001\u540c\u6642\u306b\u5b9f\u884c\u3055\u308c\u308b\u4ed6\u306e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u304b\u3089\u306f\u5f53\u8a72\u306e\u884c\u304c\u53c2\u7167\u3067\u304d\u306a\u3044\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002 \u73fe\u8c61\u306e\u8aac\u660e \u6b21\u306e\u3088\u3046\u306aSQL\u3092\u8003\u3048\u307e\u3059\u3002 begin; -- delete-insert\u306b\u3088\u3063\u3066\u30c7\u30fc\u30bf\u3092\u66f4\u65b0\u3059\u308b delete from users where id = 1; -- id \u2026","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftech-book.precena.co.jp%2Fentry%2Fsoftware%2Fbackend%2Fdb%2Facquiring_lock_for_deletion_row_postgres\" title=\"PostgreSQL\u306b\u304a\u3051\u308b\u3001\u524a\u9664\u884c\u306b\u5bfe\u3059\u308b\u30ed\u30c3\u30af\u7372\u5f97\u6642\u306e\u6319\u52d5 - Precena Tech Book\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/precena_engineer/","image_url":null,"blog_title":"Precena Tech Book","blog_url":"https://tech-book.precena.co.jp/"}