SQL - PostgreSQL, Transaction, Save Point, Isolation Level, Phenomena
ยท
๐Ÿงฉ SQL
โœ… Transaction์ด๋ž€?Transaction = ์—ฌ๋Ÿฌ ์ž‘์—…์„ “ํ•˜๋‚˜์˜ ๋ฌถ์Œ”์œผ๋กœ ์ฒ˜๋ฆฌํ•˜๋Š” ๋‹จ์œ„ ์—ฌ๋Ÿฌ SQL ์ฟผ๋ฆฌ์— ๊ฑธ์ณ ๋ฐ์ดํ„ฐ ๋ฌด๊ฒฐ์„ฑ(integrity)์„ ๊ฐ•์ œํ•œ๋‹ค.์€ํ–‰, ํ•ญ๊ณต์‚ฌ, ์˜จ๋ผ์ธ ํ‹ฐ์ผ“ ์˜ˆ๋งค ์‹œ์Šคํ…œ ๋“ฑ ์ค‘์š”ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ๋‹ค๋ฃจ๋Š” ์‚ฐ์—…๋“ค์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๊ฐœ๋…์ด๋‹ค. Commit; ๋˜๊ธฐ ์ „๊นŒ์ง€ ํ•œ Transaction์—์„œ ๋งŒ๋“  ๋ณ€๊ฒฝ์‚ฌํ•ญ์€ ๋‹ค๋ฅธ Transaction์—์„œ ๋ณด์ด์ง€ ์•Š๋Š”๋‹ค.(SELECT, UPDATE, DELETE ๊ฐ™์€ ๋ฌธ๋“ค์€ ์‚ฌ์‹ค ํ•˜๋‚˜์˜ ์ž‘์€ Transaction๋“ค์ด๋‹ค.)Transaction์˜ 4๊ฐ€์ง€ ์„ฑ์งˆ Transaction ์‚ฌ์šฉ๋ฒ•BEGIN;UPDATE accountsSET balance = balance - 500WHERE account_holder = 'nico';SELECT *FROM ..