SET TRANSACTION

NAME
SYNOPSIS
DESCRIPTION æè¿°
NOTES 注æ
COMPATIBILITY å¼å®¹æ§
è¯è
è·

---

NAME

SET TRANSACTION - 设置å½åäºå¡çç¹æ§

SYNOPSIS

SET TRANSACTION
[ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]
SET SESSION CHARACTERISTICS AS TRANSACTION
[ ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE } ] [ READ WRITE | READ ONLY ]

DESCRIPTION æè¿°

SET TRANSACTION å½ä»¤ä¸ºå½åäºå¡è®¾ç½®ç¹æ§ã å®å¯¹åé¢çäºå¡æ²¡æå½±åã SET SESSION CHARACTERISTICS 为ä¸ä¸ªä¼è¯ä¸çæ¯ä¸ªäºå¡è®¾ç½®ç¼ºççé离级å«ã SET TRANSACTION å¯ä»¥ä¸ºä¸ä¸ªç¬ç«çäºå¡è¦çä¸é¢ç设置ã

å¯ç¨çäºå¡ç¹æ§æ¯äºå¡é离级å«åäºå¡è®¿é®æ¨¡å¼ï¼è¯»/åæèåªè¯»ï¼ã

äºå¡çé离级å«å³å®ä¸ä¸ªäºå¡å¨åæ¶å- å¨å¶å®å¹¶è¡è¿è¡çäºå¡æ¶å®è½å¤çå°ä»ä¹æ°æ®ã
READ COMMITTED

ä¸æ¡è¯å¥åªè½çå°å¨å®å¼å§ä¹åçæ°æ®ãè¿æ¯ç¼ºçã

SERIALIZABLE

å½åçäºå¡åªè½çå°å¨è¿æ¬¡äºå¡ç¬¬ä¸æ¡æ¥è¯¢æèä¿®æ¹æ°æ®çè¯- å¥æ§è¡ä¹åçæ°æ®ã

Tip: æ示: 说ç½äºï¼serializableï¼å¯ä¸²è¡åï¼æå³ç两个äºå¡å°ææ°æ®åºä¿æå¨åä¸ä¸ªç¶æï¼ å°±å¥½è±¡è¿ä¸¤ä¸ªäºå¡æ¯ä¸¥æ ¼å°æç§åå顺åºæ§è¡å°é£æ ·ã

äºå¡é离级å«å¨äºå¡ä¸ç¬¬ä¸ä¸ªæ°æ®ä¿®æ¹è¯å¥ (SELECT, INSERT, DELETE, UPDATE, FETCH, COPY) æ§è¡ä¹åå°±ä¸è½å次设置ã åé Chapter 12 ‘‘Concurrency Control’’ è·åæå³äºå¡é离级å«å并åæ§æ§å¶çæ´å¤ä¿¡æ¯ã

äºå¡è®¿é®æ¨¡å¼å³å®äºå¡æ¯è¯»/åè¿æ¯åªè¯»ã读/åæ¯ç¼ºçãå¦æä¸ä¸ª äºå¡æ¯åªè¯»ï¼èä¸åå¥ç表ä¸æ¯ä¸´æ¶è¡¨ï¼é£ä¹ä¸é¢ç SQL å½ä»¤æ¯ä¸å许çï¼INSERTï¼ UPDATEï¼DELETEï¼å COPY TOï¼ èææç CREATEï¼ALTERï¼å DROP å½ä»¤ï¼ COMMENTï¼GRANTï¼REVOKEï¼ TRUNCATEï¼å EXPLAIN ANALYZE åEXECUTE é½ä¸å许ãè¿æ¯ä¸ä¸ªé«å±æ¬¡çåªè¯»æ¦å¿µï¼å®å¹¶ä¸é»æ¢å¯¹ç£ççåå¥ã

NOTES 注æ

ä¼è¯ç缺çäºå¡é离级å«ä¹å¯ä»¥ç¨å½ä»¤

SET default_transaction_isolation = ’value’

以åå¨éç½®æ件é设置ã åè Section 16.4 ‘‘Run-time Configuration’’ è·åæ´å¤ä¿¡æ¯ã

COMPATIBILITY å¼å®¹æ§

两个å½ä»¤é½å¨ SQL æ åéå®ä¹äºãSQL éç缺çäºå¡é离级å«æ¯ SERIALIZABLEï¼ å¨ PostgreSQL éï¼ç¼ºçé离级å«æ¯ READ COMMITEDï¼ä½æ¯ä½ å¯ä»¥ç¨ä¸é¢çæè¿°ä¿®æ¹å®ã PostgreSQL 并没ææä¾éç¦»çº§å« READ UNCOMMITTED å REPEATABLE READã å ä¸ºå¤çæ¬å¹¶åæ§å¶ï¼SERIALIZABLE 级å«å¹¶éçæ£çå¯ä¸²è¡åãåé Chapter 12 ‘‘Concurrency Control’’ è·åç»èã

å¨ SQL æ åéè¿æå¦å¤ä¸ç§äºå¡ç¹æ§å¯ä»¥ç¨è¿äºå½ä»¤è®¾ç½®ï¼è¯æ- èå´ç大å°ãè¿ä¸ªæ¦å¿µåªç¨äºåµå¥ç SQLã

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---