PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

SET CONSTRAINTS

劉䓄

SET CONSTRAINTS -- 螆䘞嘷嬉庋媇䔇亥溘演昖昇嚟

臺濘

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

柟誄

SET CONSTRAINTS 螆䘞嘷嬉庋媇麯䔇亥溘演昖䔇䬹攓㔗IMMEDIATE 亥溘滇婘懟溇臺埖劯麵誕臯演昖㔗DEFERRED 亥溘婔䕘彄庋媇柊庴施欉演昖㔗懟婻亥溘鄘橬躻噌䔇 IMMEDIATEDEFERRED 昇嚟㔗

傯录傺䔇施唍嚔哋婔婻亥溘攂滇䂍垔婺 DEFERRABLE INITIALLY DEFERRED, DEFERRABLE INITIALLY IMMEDIATE, NOT DEFERRABLE 婬婻䬹攓幋婔㔗丸婬䓉攂滇 IMMEDIATE 幽婫婉嚔埖 SET CONSTRAINTS 嘌巉㔗崘婴䓉傖毺垔䔇桹嚟劇媘懟婻庋媇嘖滇傡傸䔇臯婺埇傖婘庋媇麯䫘 SET CONSTRAINTS 櫹埻㔗

婥五婔婻亥溘劉彖臘䔇 SET CONSTRAINTS 櫹埻認底亥溘䔇昇嚟(鄘媙釂滇埇毘誘䔇)㔗套悩橬崔婻亥溘对陉昊婻劉庖闼幽欔橬鄘嚔赆嘌巉㔗SET CONSTRAINTS ALL 櫹埻欔橬埇毘誘亥溘䔇昇嚟㔗

SET CONSTRAINTS 檪婔婻亥溘傯 DEFERRED 櫹潊 IMMEDIATE 䔇施唍桄昇嚟埉嘩䫘嚟婄蕙嘩䫘傂嘘儖婘庋媇䂷溘庖崺誕臯䔇昄扞媞櫹鄘儖婘 SET CONSTRAINTS 䔇施唍欓臯演昖㔗套悩誺埉庖傂嘘亥溘SET CONSTRAINTS 鄘嚔崌蘖(幽婫婉嚔媞櫹亥溘昇嚟)㔗啹溴SET CONSTRAINTS 埇傖䫘庯嚺彽婘庋媇婺昊婔䗹誕臯亥溘演昖㔗

䕞嬉埻橬崡髞亥溘赆認婻螆䘞嘌巉㔗演昖启嫇婔亥溘攂滇婉埇毘誘䔇㔗

濘懟

認婻变傴埻婘嘷嬉庋媇麯媞櫹亥溘䔇臯婺㔗啹溴套悩嘹婘庋媇庖幋崡(BEGIN/COMMIT 凹)欓臯認婻变傴垄儖澇橬傂嘘嘩䫘㔗

噚垹攓

認溇变傴婯 SQL 湺庖麯垔幬䔇臯婺噚垹埻婉誺婘 PostgreSQL 麯垄埻锗䫘庯崡髞亥溘㔗


劯锔饡釕嬉誕
SET婪婔亓SET ROLE