📄 plpgsql.out
字号:
----------------------+----------+----------------------+---------------------- WS.001.1a | 001 | | PS.base.a1 WS.001.1b | 001 | | PS.base.a2 WS.001.2a | 001 | | PS.base.a3 WS.001.2b | 001 | | PS.base.a4 WS.001.3a | 001 | | PS.base.a6 WS.001.3b | 001 | | (6 rows)select * from PSlot where slotname ~ 'PS.base.a' order by slotname; slotname | pfname | slotlink | backlink ----------------------+--------+----------------------+---------------------- PS.base.a1 | PF0_1 | | WS.001.1a PS.base.a2 | PF0_1 | | WS.001.1b PS.base.a3 | PF0_1 | | WS.001.2a PS.base.a4 | PF0_1 | | WS.001.2b PS.base.a5 | PF0_1 | | PS.base.a6 | PF0_1 | | WS.001.3a (6 rows)update WSlot set backlink = 'PS.base.a6' where slotname = 'WS.001.3b';select * from WSlot where roomno = '001' order by slotname; slotname | roomno | slotlink | backlink ----------------------+----------+----------------------+---------------------- WS.001.1a | 001 | | PS.base.a1 WS.001.1b | 001 | | PS.base.a2 WS.001.2a | 001 | | PS.base.a3 WS.001.2b | 001 | | PS.base.a4 WS.001.3a | 001 | | WS.001.3b | 001 | | PS.base.a6 (6 rows)select * from PSlot where slotname ~ 'PS.base.a' order by slotname; slotname | pfname | slotlink | backlink ----------------------+--------+----------------------+---------------------- PS.base.a1 | PF0_1 | | WS.001.1a PS.base.a2 | PF0_1 | | WS.001.1b PS.base.a3 | PF0_1 | | WS.001.2a PS.base.a4 | PF0_1 | | WS.001.2b PS.base.a5 | PF0_1 | | PS.base.a6 | PF0_1 | | WS.001.3b (6 rows)update WSlot set backlink = 'PS.base.a5' where slotname = 'WS.001.3a';select * from WSlot where roomno = '001' order by slotname; slotname | roomno | slotlink | backlink ----------------------+----------+----------------------+---------------------- WS.001.1a | 001 | | PS.base.a1 WS.001.1b | 001 | | PS.base.a2 WS.001.2a | 001 | | PS.base.a3 WS.001.2b | 001 | | PS.base.a4 WS.001.3a | 001 | | PS.base.a5 WS.001.3b | 001 | | PS.base.a6 (6 rows)select * from PSlot where slotname ~ 'PS.base.a' order by slotname; slotname | pfname | slotlink | backlink ----------------------+--------+----------------------+---------------------- PS.base.a1 | PF0_1 | | WS.001.1a PS.base.a2 | PF0_1 | | WS.001.1b PS.base.a3 | PF0_1 | | WS.001.2a PS.base.a4 | PF0_1 | | WS.001.2b PS.base.a5 | PF0_1 | | WS.001.3a PS.base.a6 | PF0_1 | | WS.001.3b (6 rows)insert into PField values ('PF1_2', 'Phonelines 1st floor');insert into PSlot values ('PS.1st.ta1', 'PF1_2', '', '');insert into PSlot values ('PS.1st.ta2', 'PF1_2', '', '');insert into PSlot values ('PS.1st.ta3', 'PF1_2', '', '');insert into PSlot values ('PS.1st.ta4', 'PF1_2', '', '');insert into PSlot values ('PS.1st.ta5', 'PF1_2', '', '');insert into PSlot values ('PS.1st.ta6', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb1', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb2', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb3', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb4', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb5', 'PF1_2', '', '');insert into PSlot values ('PS.1st.tb6', 'PF1_2', '', '');---- Fix the wrong name for patchfield PF0_2--update PField set name = 'PF0_2' where name = 'PF0_X';select * from PSlot order by slotname; slotname | pfname | slotlink | backlink ----------------------+--------+----------------------+---------------------- PS.1st.a1 | PF1_1 | | WS.101.1a PS.1st.a2 | PF1_1 | | WS.101.1b PS.1st.a3 | PF1_1 | | WS.101.2a PS.1st.a4 | PF1_1 | | WS.101.2b PS.1st.a5 | PF1_1 | | WS.101.3a PS.1st.a6 | PF1_1 | | WS.101.3b PS.1st.b1 | PF1_1 | | WS.102.1a PS.1st.b2 | PF1_1 | | WS.102.1b PS.1st.b3 | PF1_1 | | WS.102.2a PS.1st.b4 | PF1_1 | | WS.102.2b PS.1st.b5 | PF1_1 | | WS.102.3a PS.1st.b6 | PF1_1 | | WS.102.3b PS.1st.c1 | PF1_1 | | WS.105.1a PS.1st.c2 | PF1_1 | | WS.105.1b PS.1st.c3 | PF1_1 | | WS.105.2a PS.1st.c4 | PF1_1 | | WS.105.2b PS.1st.c5 | PF1_1 | | WS.105.3a PS.1st.c6 | PF1_1 | | WS.105.3b PS.1st.d1 | PF1_1 | | WS.106.1a PS.1st.d2 | PF1_1 | | WS.106.1b PS.1st.d3 | PF1_1 | | WS.106.2a PS.1st.d4 | PF1_1 | | WS.106.2b PS.1st.d5 | PF1_1 | | WS.106.3a PS.1st.d6 | PF1_1 | | WS.106.3b PS.1st.ta1 | PF1_2 | | PS.1st.ta2 | PF1_2 | | PS.1st.ta3 | PF1_2 | | PS.1st.ta4 | PF1_2 | | PS.1st.ta5 | PF1_2 | | PS.1st.ta6 | PF1_2 | | PS.1st.tb1 | PF1_2 | | PS.1st.tb2 | PF1_2 | | PS.1st.tb3 | PF1_2 | | PS.1st.tb4 | PF1_2 | | PS.1st.tb5 | PF1_2 | | PS.1st.tb6 | PF1_2 | | PS.base.a1 | PF0_1 | | WS.001.1a PS.base.a2 | PF0_1 | | WS.001.1b PS.base.a3 | PF0_1 | | WS.001.2a PS.base.a4 | PF0_1 | | WS.001.2b PS.base.a5 | PF0_1 | | WS.001.3a PS.base.a6 | PF0_1 | | WS.001.3b PS.base.b1 | PF0_1 | | WS.002.1a PS.base.b2 | PF0_1 | | WS.002.1b PS.base.b3 | PF0_1 | | WS.002.2a PS.base.b4 | PF0_1 | | WS.002.2b PS.base.b5 | PF0_1 | | WS.002.3a PS.base.b6 | PF0_1 | | WS.002.3b PS.base.c1 | PF0_1 | | WS.003.1a PS.base.c2 | PF0_1 | | WS.003.1b PS.base.c3 | PF0_1 | | WS.003.2a PS.base.c4 | PF0_1 | | WS.003.2b PS.base.c5 | PF0_1 | | WS.003.3a PS.base.c6 | PF0_1 | | WS.003.3b PS.base.ta1 | PF0_2 | | PS.base.ta2 | PF0_2 | | PS.base.ta3 | PF0_2 | | PS.base.ta4 | PF0_2 | | PS.base.ta5 | PF0_2 | | PS.base.ta6 | PF0_2 | | PS.base.tb1 | PF0_2 | | PS.base.tb2 | PF0_2 | | PS.base.tb3 | PF0_2 | | PS.base.tb4 | PF0_2 | | PS.base.tb5 | PF0_2 | | PS.base.tb6 | PF0_2 | | (66 rows)select * from WSlot order by slotname; slotname | roomno | slotlink | backlink ----------------------+----------+----------------------+---------------------- WS.001.1a | 001 | | PS.base.a1 WS.001.1b | 001 | | PS.base.a2 WS.001.2a | 001 | | PS.base.a3 WS.001.2b | 001 | | PS.base.a4 WS.001.3a | 001 | | PS.base.a5 WS.001.3b | 001 | | PS.base.a6 WS.002.1a | 002 | | PS.base.b1 WS.002.1b | 002 | | PS.base.b2 WS.002.2a | 002 | | PS.base.b3 WS.002.2b | 002 | | PS.base.b4 WS.002.3a | 002 | | PS.base.b5 WS.002.3b | 002 | | PS.base.b6 WS.003.1a | 003 | | PS.base.c1 WS.003.1b | 003 | | PS.base.c2 WS.003.2a | 003 | | PS.base.c3 WS.003.2b | 003 | | PS.base.c4 WS.003.3a | 003 | | PS.base.c5 WS.003.3b | 003 | | PS.base.c6 WS.101.1a | 101 | | PS.1st.a1 WS.101.1b | 101 | | PS.1st.a2 WS.101.2a | 101 | | PS.1st.a3 WS.101.2b | 101 | | PS.1st.a4 WS.101.3a | 101 | | PS.1st.a5 WS.101.3b | 101 | | PS.1st.a6 WS.102.1a | 102 | | PS.1st.b1 WS.102.1b | 102 | | PS.1st.b2 WS.102.2a | 102 | | PS.1st.b3 WS.102.2b | 102 | | PS.1st.b4 WS.102.3a | 102 | | PS.1st.b5 WS.102.3b | 102 | | PS.1st.b6 WS.105.1a | 105 | | PS.1st.c1 WS.105.1b | 105 | | PS.1st.c2 WS.105.2a | 105 | | PS.1st.c3 WS.105.2b | 105 | | PS.1st.c4 WS.105.3a | 105 | | PS.1st.c5 WS.105.3b | 105 | | PS.1st.c6 WS.106.1a | 106 | | PS.1st.d1 WS.106.1b | 106 | | PS.1st.d2 WS.106.2a | 106 | | PS.1st.d3 WS.106.2b | 106 | | PS.1st.d4 WS.106.3a | 106 | | PS.1st.d5 WS.106.3b | 106 | | PS.1st.d6 (42 rows)---- Install the central phone system and create the phone numbers.-- They are weired on insert to the patchfields. Again the-- triggers automatically tell the PSlots to update their-- backlink field.--insert into PLine values ('PL.001', '-0', 'Central call', 'PS.base.ta1');insert into PLine values ('PL.002', '-101', '', 'PS.base.ta2');insert into PLine values ('PL.003', '-102', '', 'PS.base.ta3');insert into PLine values ('PL.004', '-103', '', 'PS.base.ta5');insert into PLine values ('PL.005', '-104', '', 'PS.base.ta6');insert into PLine values ('PL.006', '-106', '', 'PS.base.tb2');insert into PLine values ('PL.007', '-108', '', 'PS.base.tb3');insert into PLine values ('PL.008', '-109', '', 'PS.base.tb4');insert into PLine values ('PL.009', '-121', '', 'PS.base.tb5');insert into PLine values ('PL.010', '-122', '', 'PS.base.tb6');insert into PLine values ('PL.015', '-134', '', 'PS.1st.ta1');insert into PLine values ('PL.016', '-137', '', 'PS.1st.ta3');insert into PLine values ('PL.017', '-139', '', 'PS.1st.ta4');insert into PLine values ('PL.018', '-362', '', 'PS.1st.tb1');insert into PLine values ('PL.019', '-363', '', 'PS.1st.tb2');insert into PLine values ('PL.020', '-364', '', 'PS.1st.tb3');insert into PLine values ('PL.021', '-365', '', 'PS.1st.tb5');insert into PLine values ('PL.022', '-367', '', 'PS.1st.tb6');insert into PLine values ('PL.028', '-501', 'Fax entrance', 'PS.base.ta2');insert into PLine values ('PL.029', '-502', 'Fax 1st floor', 'PS.1st.ta1');---- Buy some phones, plug them into the wall and patch the-- phone lines to the corresponding patchfield slots.--insert into PHone values ('PH.hc001', 'Hicom standard', 'WS.001.1a');update PSlot set slotlink = 'PS.base.ta1' where slotname = 'PS.base.a1';insert into PHone values ('PH.hc002', 'Hicom standard', 'WS.002.1a');update PSlot set slotlink = 'PS.base.ta5' where slotname = 'PS.base.b1';insert into PHone values ('PH.hc003', 'Hicom standard', 'WS.002.2a');update PSlot set slotlink = 'PS.base.tb2' where slotname = 'PS.base.b3';insert into PHone values ('PH.fax001', 'Canon fax', 'WS.001.2a');update PSlot set slotlink = 'PS.base.ta2' where slotname = 'PS.base.a3';---- Install a hub at one of the patchfields, plug a computers-- ethernet interface into the wall and patch it to the hub.--insert into Hub values ('base.hub1', 'Patchfield PF0_1 hub', 16);insert into System values ('orion', 'PC');insert into IFace values ('IF', 'orion', 'eth0', 'WS.002.1b');update PSlot set slotlink = 'HS.base.hub1.1' where slotname = 'PS.base.b2';---- Now we take a look at the patchfield--select * from PField_v1 where pfname = 'PF0_1' order by slotname; pfname | slotname | backside | patch --------+----------------------+----------------------------------------------------------+----------------------------------------------- PF0_1 | PS.base.a1 | WS.001.1a in room 001 -> Phone PH.hc001 (Hicom standard) | PS.base.ta1 -> Phone line -0 (Central call) PF0_1 | PS.base.a2 | WS.001.1b in room 001 -> - | - PF0_1 | PS.base.a3 | WS.001.2a in room 001 -> Phone PH.fax001 (Canon fax) | PS.base.ta2 -> Phone line -501 (Fax entrance) PF0_1 | PS.base.a4 | WS.001.2b in room 001 -> - | - PF0_1 | PS.base.a5 | WS.001.3a in room 001 -> - | - PF0_1 | PS.base.a6 | WS.001.3b in room 001 -> - | - PF0_1 | PS.base.b1 | WS.002.1a in room 002 -> Phone PH.hc002 (Hicom standard) | PS.base.ta5 -> Phone line -103 PF0_1 | PS.base.b2 | WS.002.1b in room 002 -> orion IF eth0 (PC) | Patchfield PF0_1 hub slot 1 PF0_1 | PS.base.b3 | WS.002.2a in room 002 -> Phone PH.hc003 (Hicom standard) | PS.base.tb2 -> Phone line -106 PF0_1 | PS.base.b4 | WS.002.2b in room 002 -> - | - PF0_1 | PS.base.b5 | WS.002.3a in room 002 -> - | - PF0_1 | PS.base.b6 | WS.002.3b in room 002 -> - | - PF0_1 | PS.base.c1 | WS.003.1a in room 003 -> - | - PF0_1 | PS.base.c2 | WS.003.1b in room 003 -> - | - PF0_1 | PS.base.c3 | WS.003.2a in room 003 -> - | - PF0_1 | PS.base.c4 | WS.003.2b in room 003 -> - | - PF0_1 | PS.base.c5 | WS.003.3a in room 003 -> - | - PF0_1 | PS.base.c6 | WS.003.3b in room 003 -> - | -(18 rows)select * from PField_v1 where pfname = 'PF0_2' order by slotname; pfname | slotname | backside | patch --------+----------------------+--------------------------------+------------------------------------------------------------------------ PF0_2 | PS.base.ta1 | Phone line -0 (Central call) | PS.base.a1 -> WS.001.1a in room 001 -> Phone PH.hc001 (Hicom standard) PF0_2 | PS.base.ta2 | Phone line -501 (Fax entrance) | PS.base.a3 -> WS.001.2a in room 001 -> Phone PH.fax001 (Canon fax) PF0_2 | PS.base.ta3 | Phone line -102 | - PF0_2 | PS.base.ta4 | - | - PF0_2 | PS.base.ta5 | Phone line -103 | PS.base.b1 -> WS.002.1a in room 002 -> Phone PH.hc002 (Hicom standard) PF0_2 | PS.base.ta6 | Phone line -104 | - PF0_2 | PS.base.tb1 | - | - PF0_2 | PS.base.tb2 | Phone line -106 | PS.base.b3 -> WS.002.2a in room 002 -> Phone PH.hc003 (Hicom standard) PF0_2 | PS.base.tb3 | Phone line -108 | - PF0_2 | PS.base.tb4 | Phone line -109 | - PF0_2 | PS.base.tb5 | Phone line -121 | - PF0_2 | PS.base.tb6 | Phone line -122 | -(12 rows)---- Finally we want errors--insert into PField values ('PF1_1', 'should fail due to unique index');ERROR: duplicate key value violates unique constraint "pfield_name"update PSlot set backlink = 'WS.not.there' where slotname = 'PS.base.a1';ERROR: WS.not.there does not existCONTEXT: PL/pgSQL function "tg_backlink_a" line 16 at assignmentupdate PSlot set backlink = 'XX.illegal' where slotname = 'PS.base.a1';ERROR: illegal backlink beginning with XXCONTEXT: PL/pgSQL function "tg_backlink_a" line 16 at assignmentupdate PSlot set slotlink = 'PS.not.there' where slotname = 'PS.base.a1';ERROR: PS.not.there does not existCONTEXT: PL/pgSQL function "tg_slotl⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -