PostgreSQLトランザクションã¨DBD::Pgã®è¬Žã®æŒ™å‹•PostgreSQLã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä»•æ§˜ DBD::Pgã®è¬Ž 謎ã®è§£æž 追記 メモ PostgreSQLã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä»•æ§˜ CREATE TABLE test(x INT UNIQUE); INSERT INTO test (x) VALUES (1); INSERT INTO test (x) VALUES (2); ã¨ã—ã¦ãŠãã¾ã™ã€‚ ã“ã“ã§ã€ => BEGIN; => INSERT INTO test (x) VALUES (3); INSERT 0 1 => INSERT INTO test (x) VALUES (1); ERROR: duplicate key value violates unique constraint "test_x_key" ã¨ã™ã‚‹ã¨ã‚¨ãƒ©ãƒ¼ã«ãªã‚Šã¾ã™ã€‚PostgreSQLã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä¸ã«ã‚¨ãƒ©ãƒ¼ãŒèµ·ã“ã‚‹ã¨ã€ä»¥å¾Œä½•ã‚’ã—ã¦ã‚‚エラーã«ãªã‚Šå—ã‘付ã‘
{{#tags}}- {{label}}
{{/tags}}