- Notifications
You must be signed in to change notification settings - Fork5
Commit08be00f
committed
Fix plpython's handling of functions used as triggers on multiple tables.
plpython tried to use a single cache entry for a trigger function, but itneeds a separate cache entry for each table the trigger is applied to,because there is table-dependent data in there. This was done correctlybefore 9.1, but commit46211da broke itby simplifying the lookup key from "function OID and triggered table OID"to "function OID and is-trigger boolean". Go back to using both OIDsas the lookup key. Per bug report from Sandro Santilli.Andres Freund1 parentbb1e504 commit08be00f
File tree
5 files changed
+99
-41
lines changed- src/pl/plpython
- expected
- sql
5 files changed
+99
-41
lines changedLines changed: 24 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
610 | 610 |
| |
611 | 611 |
| |
612 | 612 |
| |
| 613 | + | |
| 614 | + | |
| 615 | + | |
| 616 | + | |
| 617 | + | |
| 618 | + | |
| 619 | + | |
| 620 | + | |
| 621 | + | |
| 622 | + | |
| 623 | + | |
| 624 | + | |
| 625 | + | |
| 626 | + | |
| 627 | + | |
| 628 | + | |
| 629 | + | |
| 630 | + | |
| 631 | + | |
| 632 | + | |
| 633 | + | |
| 634 | + | |
| 635 | + | |
| 636 | + |
Lines changed: 7 additions & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
14 | 14 |
| |
15 | 15 |
| |
16 | 16 |
| |
| 17 | + | |
17 | 18 |
| |
18 | 19 |
| |
19 | 20 |
| |
| |||
174 | 175 |
| |
175 | 176 |
| |
176 | 177 |
| |
177 |
| - | |
| 178 | + | |
| 179 | + | |
178 | 180 |
| |
179 | 181 |
| |
180 | 182 |
| |
| |||
215 | 217 |
| |
216 | 218 |
| |
217 | 219 |
| |
| 220 | + | |
218 | 221 |
| |
219 | 222 |
| |
220 | 223 |
| |
221 | 224 |
| |
| 225 | + | |
222 | 226 |
| |
223 | 227 |
| |
224 |
| - | |
| 228 | + | |
225 | 229 |
| |
226 | 230 |
| |
227 | 231 |
| |
228 | 232 |
| |
229 | 233 |
| |
230 | 234 |
| |
231 |
| - | |
| 235 | + | |
232 | 236 |
| |
233 | 237 |
| |
234 | 238 |
| |
|
Lines changed: 41 additions & 36 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
24 | 24 |
| |
25 | 25 |
| |
26 | 26 |
| |
27 |
| - | |
28 | 27 |
| |
29 | 28 |
| |
30 | 29 |
| |
| |||
38 | 37 |
| |
39 | 38 |
| |
40 | 39 |
| |
41 |
| - | |
| 40 | + | |
42 | 41 |
| |
43 |
| - | |
| 42 | + | |
44 | 43 |
| |
45 | 44 |
| |
46 |
| - | |
47 |
| - | |
48 |
| - | |
49 |
| - | |
50 |
| - | |
51 |
| - | |
52 |
| - | |
53 | 45 |
| |
54 | 46 |
| |
55 | 47 |
| |
| |||
69 | 61 |
| |
70 | 62 |
| |
71 | 63 |
| |
72 |
| - | |
73 |
| - | |
74 |
| - | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
| 72 | + | |
75 | 73 |
| |
76 | 74 |
| |
77 |
| - | |
| 75 | + | |
78 | 76 |
| |
| 77 | + | |
79 | 78 |
| |
80 |
| - | |
81 |
| - | |
| 79 | + | |
| 80 | + | |
| 81 | + | |
| 82 | + | |
82 | 83 |
| |
83 | 84 |
| |
84 | 85 |
| |
85 | 86 |
| |
86 | 87 |
| |
87 |
| - | |
88 |
| - | |
89 |
| - | |
90 |
| - | |
91 |
| - | |
92 |
| - | |
93 |
| - | |
| 88 | + | |
| 89 | + | |
| 90 | + | |
| 91 | + | |
| 92 | + | |
| 93 | + | |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
94 | 100 |
| |
95 | 101 |
| |
96 | 102 |
| |
97 | 103 |
| |
98 | 104 |
| |
99 |
| - | |
100 |
| - | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
| 108 | + | |
101 | 109 |
| |
102 |
| - | |
| 110 | + | |
103 | 111 |
| |
104 | 112 |
| |
105 |
| - | |
106 |
| - | |
107 |
| - | |
| 113 | + | |
| 114 | + | |
| 115 | + | |
| 116 | + | |
108 | 117 |
| |
109 | 118 |
| |
110 | 119 |
| |
111 | 120 |
| |
112 | 121 |
| |
113 | 122 |
| |
114 |
| - | |
115 |
| - | |
116 |
| - | |
117 |
| - | |
118 |
| - | |
119 |
| - | |
| 123 | + | |
| 124 | + | |
120 | 125 |
| |
121 | 126 |
| |
122 | 127 |
| |
123 | 128 |
| |
124 | 129 |
| |
125 | 130 |
| |
126 |
| - | |
| 131 | + | |
127 | 132 |
| |
128 | 133 |
| |
129 | 134 |
| |
|
Lines changed: 9 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
32 | 32 |
| |
33 | 33 |
| |
34 | 34 |
| |
| 35 | + | |
| 36 | + | |
| 37 | + | |
| 38 | + | |
| 39 | + | |
| 40 | + | |
| 41 | + | |
35 | 42 |
| |
36 | 43 |
| |
37 | 44 |
| |
38 |
| - | |
| 45 | + | |
39 | 46 |
| |
40 | 47 |
| |
41 | 48 |
| |
42 | 49 |
| |
43 | 50 |
| |
44 |
| - | |
| 51 | + | |
45 | 52 |
| |
46 | 53 |
| |
47 | 54 |
| |
|
Lines changed: 18 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
388 | 388 |
| |
389 | 389 |
| |
390 | 390 |
| |
| 391 | + | |
| 392 | + | |
| 393 | + | |
| 394 | + | |
| 395 | + | |
| 396 | + | |
| 397 | + | |
| 398 | + | |
| 399 | + | |
| 400 | + | |
| 401 | + | |
| 402 | + | |
| 403 | + | |
| 404 | + | |
| 405 | + | |
| 406 | + | |
| 407 | + | |
| 408 | + |
0 commit comments
Comments
(0)