END

Name

END -- ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)¸¦ Ä¿¹ÔÇÑ´Ù

Synopsis

END [ WORK | TRANSACTION ]

¼³¸í

END´Â ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)¸¦ Ä¿¹ÔÇÕ´Ï´Ù. À̰Ϳ¡ ÀÇÇØ ±× Æ®·£Àè¼Ç(transaction) (·Î) ÀÌ·ç¾îÁø ¸ðµç º¯°æÀº ±× ¹Û¿¡ ´ëÇØ °¡½Ã »óŰ¡ µË´Ï´Ù. ¶Ç, Ãæµ¿ÀÌ ¹ß»ýÇÑ´Ù°í ÇØµµ ¿µ¼Ó¼ºÀÌ º¸ÁõµË´Ï´Ù. ÀÌ ¸í·É¹®Àº PostgreSQLÀÇ È®ÀåÀ¸·Î COMMIT ¶ó°í µ¿µîÇÕ´Ï´Ù.

¸Å°³º¯¼ö

WORK
TRANSACTION

»ý·« °¡´ÉÇÑ Å°¿öµåÀÔ´Ï´Ù. ¾Æ¹«°Íµµ È¿°ú°¡ ¾ø½À´Ï´Ù.

ÁÖ¼®

Æ®·£Àè¼Ç(transaction)ÀÇ Áß´Ü(abort)¿¡´Â ROLLBACK À» »ç¿ëÇØ ÁÖ¼¼¿ä.

Æ®·£Àè¼Ç(transaction)ÀÇ ¿ÜÃø¿¡¼­END¸¦ ¹ßÇàÇØµµ ¹®Á¦´Â ¾ø½À´Ï´Ù¸¸, °æ°í ¸Þ¼¼Áö°¡ Ç¥½ÃµË´Ï´Ù.

¿¹Á¦

ÇöÀçÀÇ Æ®·£Àè¼Ç(transaction)¸¦ Ä¿¹ÔÇÏ°í ¸ðµç º¯°æÀ» ¿µ¼ÓÈ­ÇÕ´Ï´Ù.

END;

ȣȯ¼º

END´ÂPostgreSQLÀÇ È®ÀåÀÔ´Ï´Ù. ÀÌ Ä¿¸àµåÀÇ ±â´ÉÀº Ç¥ÁØ SQL·Î ±ÔÁ¤µÇ¾î ÀÖ´Â COMMIT °Í°ú ´ëÀÀµÇ´Â ±â´ÉÀ» Á¦°øÇÕ´Ï´Ù.

°ü·Ã Ç׸ñ

BEGIN , COMMIT , ROLLBACK