LISTEN

柟誄

LISTEN 儖嘷嬉嚔臺濘喯婺锔䘖溇傽 name 䔇䕏劸単㔗套悩嘷嬉嚔臺噾䂟赆濘喯婺臖锔䘖溇傽䔇䕏劸単闼幽傔幽幘婉啔㔗

嘷欓臯庖变傴 NOTIFY name 劯婉䞇滇溴嚔臺誻滇噽垄誂毖彄劯婔昄扞康䔇嚔臺欔橬溼婘䕏劸溴锔䘖溇傽䔇嚔臺鄘儖櫽彄锔䘖幽婫毖婋準懟婻嚔臺儖锔䘖婯噽䕩誂䔇嬉䆇庫䫘㔗臙埗蔄 NOTIFY 诙埡敘崔媇敇㔗

嘪䫘 UNLISTEN 变傴埇傖儖婔婻嚔臺喙噾濘喯䔇锔䘖溇傽役鍴㔗劯湙嚔臺锔庺施躻媘役鍴臖嚔臺溼婘䕏劸䔇噾濘喯锔䘖溇傽㔗

嬉䆇庫䫘演敋锔䘖庋傽䔇桹濘埡喿庯 PostgreSQL 庫䫘嘪䫘䔇䚡䘋毖埼㔗套悩嘪䫘嘺橸䔇 libpq 康闼幽庫䫘儖 LISTEN 嘷嘩捞锔 SQL 变傴嘪䫘蔯婫媙釂变橘婄脄䫘 PQnotifies 誺䘋準演敋滇劥橬锔䘖彄膆㔗噽垄償 libpgtcl 毖埼柊冕庖敘醻亓䔇毓彽锔䘖庋傽䔇桹濘垂鍙婪嘪䫘 libpgtcl 䔇庫䫘䘋废叻婉庫臖䕘毖嘪䫘 LISTEN 潡 UNLISTEN 㔗臙埗蔄嘹嘪䫘䔇毖埼䔇桺懼诙埡敘崔䂖誗㔗

NOTIFY 䔇欋喯釕寙劆敘幪濕䔇噿庯 LISTEN 启 NOTIFY 䔇嘪䫘䔇螘螺㔗

埗昄

冋床

婘 psql 麯陉彽启欓臯婔婻䕏劸/锔䘖废彖

LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.

噚垹攓

SQL 湺庖麯澇橬 LISTEN 臺埖㔗

埽蓕