SET CONSTRAINTS

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

---

NAME

SET CONSTRAINTS - 设置å½åäºå¡ç约æ模å¼

SYNOPSIS

SET CONSTRAINTS { ALL | name [, ...] } { DEFERRED | IMMEDIATE }

DESCRIPTION æè¿°

SET CONSTRAINTS 设置å½åäºå¡éç约æè¿ç®çç¹æ§ã å¨ IMMEDIATE 模å¼ä¸ï¼çº¦ææ¯å¨æ¯æ¡è¯å¥åé¢è¿è¡æ£æ¥çã å¨ DEFERRED 模å¼ä¸ï¼ä¸ç´å°äºå¡æ交æ¶ææ£æ¥çº¦æã

å¨ä½ æ约æç模å¼ä¿®æ¹æ IMMEDIATE ä¹åï¼æ°ç约æ模å¼æ¯åä½ç¨å¼å°çæçï¼ ä»»ä½å°å¨çå¾çï¼éè¦å¨äºå¡ç»ææ£æ¥å°æ°æ®ä¿®æ¹ç约æï¼å¨ä½¿ç¨ DEFERRED çæ¶åï¼é½å°å¨æ§è¡ SET CONSTRAINTS å½ä»¤çæ¶å马ä¸æ£æ¥ã

ä»å建çæ¶åå¼å§ï¼ä¸ä¸ªçº¦ææ»æ¯è¡¨ç°ä¸ºä¸é¢ä¸ä¸ªç¹æ§ä¹ä¸ï¼ INITIALLY DEFERRED, INITIALLY IMMEDIATE DEFERRABLE, æ INITIALLY IMMEDIATE NOT DEFERRABLEã 第ä¸ä¸ªç¹æ§ä¸ä¼å SET CONSTRAINTSå½±åã

ç®åï¼åªæå¤é®çº¦æ被è¿ä¸ªè®¾ç½®å½±åãæ£æ¥åå¯ä¸çº¦ææ»æ¯ç«å³æ£æ¥çèä¸æ¯å¯æ¨è¿çã

NOTES 注æ

è¿ä¸ªå½ä»¤åªå¨å½åäºå¡éä¿®æ¹çº¦æçè¡ä¸ºãå æ¤ï¼å¦æä½ å¨äºå¡åå¤é¢ ï¼BEGIN/COMMIT 对ï¼æ§è¡è¿ä¸ªå½ä»¤ï¼ å®å°æ¾å¾æ²¡æä»»ä½ä½ç¨é£æ ·ãå¦æä½ å¸æä¸å¨æ¯ä¸ªäºå¡ä¸ååº SET CONSTRAINTS ä¹è½ä¿®æ¹çº¦æçè¡ä¸ºï¼ é£ä¹å¨å建è¿äºçº¦æçæ¶å声æ INITIALLY DEFERRED æè INITIALLY IMMEDIATEã

COMPATIBILITY å¼å®¹æ§

è¿æ¡å½ä»¤ä¸ SQL æ åéå®ä¹çè¡ä¸ºå¼å®¹ï¼åªä¸è¿ï¼å¨ PostgreSQL éï¼å®åªéç¨äºå¤é®çº¦æã

è¯è

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

è·

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

---