MJVKtKc8

1CREATE TABLE "ps_counters_history"
2(
3  "id" serial PRIMARY KEY,
4  "timestamp" timestamp NOT NULL DEFAULT clock_timestamp(),
5  "psid" integer NOT NULL,
6  "counter" bigint[] NOT NULL
7);
8
9CREATE OR REPLACE FUNCTION ps_counters_history_trigger()
10  RETURNS trigger AS
11$BODY$
12  DECLARE
13    table_name text;
14  BEGIN
15    table_name := 'ps_counters_history_' || to_char(CURRENT_DATE, 'yyyy_mm');
16    IF NOT EXISTS (SELECT 1 FROM pg_class WHERE relname = table_name)
17    THEN
18      EXECUTE 'CREATE TABLE IF NOT EXISTS ' || table_name ||
19              ' () INHERITS (ps_counters_history);';
20    END IF;
21    EXECUTE 'INSERT INTO ' || table_name ||
22            '(psid, counter) VALUES ($1.psid, $1.counter);' USING NEW;
23    RETURN NEW;
24  END
25$BODY$
26  LANGUAGE plpgsql;
27
28CREATE TRIGGER ps_counters_history_trigger
29AFTER INSERT OR UPDATE ON ps_counters FOR EACH ROW
30EXECUTE PROCEDURE ps_counters_history_trigger();
31	
32[2016-12-09 11:04:28.233844] [0x00007fc72ebaa700] [error]: PlayStation (ID: 5; DallasID: MC00-0497): ERROR:  payload string too long
33CONTEXT:  SQL statement "SELECT pg_notify('addedrecord',json_build_object('dataNew',dataNew,'dataOld',dataOld,'table',TG_TABLE_NAME,'query',TG_OP,'schema',TG_TABLE_SCHEMA )::text )"
34PL/pgSQL function ps_counters_history_trigger() line 13 at PERFORM
35	
36UPDATE ps_counters SET
37counter[0] = 2035400,
38counter[1] = 723500,
39counter[2] = 5105400,
40counter[3] = 750900,
41counter[4] = 750900,
42counter[5] = 12,
43counter[6] = 10,
44counter[7] = 2,
45counter[8] = 0,
46counter[9] = 0,
47counter[10] = 0,
48counter[11] = 161500,
49counter[12] = 0,
50counter[13] = 0,
51counter[14] = 0,
52counter[15] = 0,
53counter[16] = 0,
54counter[17] = 0,
55counter[18] = 0,
56counter[19] = 0,
57counter[20] = 0,
58counter[21] = 0,
59counter[22] = 0,
60counter[23] = 1901300,
61counter[24] = 0,
62counter[25] = 0,
63counter[26] = 0,
64counter[27] = 0,
65counter[28] = 723500,
66counter[29] = 0,
67counter[30] = 0,
68counter[31] = 5105400,
69counter[32] = 0,
70counter[33] = 0,
71counter[34] = 5828900,
72counter[35] = 5856300,
73counter[36] = 2062800,
74counter[37] = 0,
75counter[38] = 12,
76counter[39] = 0,
77counter[40] = 0,
78counter[41] = 0,
79counter[42] = 0,
80counter[43] = 0,
81counter[44] = 0,
82counter[45] = 0,
83counter[46] = 1901300,
84counter[47] = 0,
85counter[48] = 0,
86counter[49] = 0,
87counter[50] = 0,
88counter[51] = 0,
89counter[52] = 0,
90counter[53] = 0,
91counter[54] = 0,
92counter[55] = 0,
93counter[56] = 0,
94counter[57] = 0,
95counter[58] = 0,
96counter[59] = 0,
97counter[60] = 0,
98counter[61] = 0,
99counter[62] = 0,
100counter[63] = 0,
101counter[64] = 5,
102counter[65] = 0,
103counter[66] = 0,
104counter[67] = 6,
105counter[68] = 0,
106counter[69] = 0,
107counter[70] = 5,
108counter[71] = 5,
109counter[72] = 4,
110counter[73] = 0,
111counter[74] = 0,
112counter[75] = 0,
113counter[76] = 0,
114counter[77] = 0,
115counter[78] = 0,
116counter[79] = 0,
117counter[80] = 0,
118counter[81] = 0,
119counter[82] = 0,
120counter[83] = 0,
121counter[84] = 0,
122counter[85] = 0,
123counter[86] = 0,
124counter[87] = 0,
125counter[88] = 0,
126counter[89] = 0,
127counter[90] = 0,
128counter[91] = 0,
129counter[92] = 0,
130counter[93] = 0,
131counter[94] = 0,
132counter[95] = 0,
133counter[96] = 0,
134counter[97] = 0,
135counter[98] = 0,
136counter[99] = 0,
137counter[100] = 0,
138counter[101] = 0,
139counter[102] = 0,
140counter[103] = 0,
141counter[104] = 0,
142counter[105] = 0,
143counter[106] = 0,
144counter[107] = 0,
145counter[108] = 0,
146counter[109] = 0,
147counter[110] = 0,
148counter[111] = 0,
149counter[112] = 0,
150counter[113] = 0,
151counter[114] = 0,
152counter[115] = 0,
153counter[116] = 0,
154counter[117] = 0,
155counter[118] = 0,
156counter[119] = 0,
157counter[120] = 0,
158counter[121] = 0,
159counter[122] = 0,
160counter[123] = 0,
161counter[124] = 0,
162counter[125] = 0,
163counter[126] = 0,
164counter[127] = 0,
165counter[128] = 0,
166counter[129] = 0,
167counter[130] = 0,
168counter[131] = 0,
169counter[132] = 0,
170counter[133] = 0,
171counter[134] = 0,
172counter[135] = 0,
173counter[136] = 0,
174counter[137] = 0,
175counter[138] = 0,
176counter[139] = 0,
177counter[140] = 0,
178counter[141] = 0,
179counter[142] = 0,
180counter[143] = 0,
181counter[144] = 0,
182counter[145] = 0,
183counter[146] = 0,
184counter[147] = 0,
185counter[148] = 0,
186counter[149] = 0,
187counter[150] = 0,
188counter[151] = 0,
189counter[152] = 0,
190counter[153] = 0,
191counter[154] = 0,
192counter[155] = 0,
193counter[156] = 0,
194counter[157] = 0,
195counter[158] = 0,
196counter[159] = 0,
197counter[160] = 0,
198counter[161] = 0,
199counter[162] = 0,
200counter[163] = 0,
201counter[164] = 0,
202counter[165] = 0,
203counter[166] = 0,
204counter[167] = 0,
205counter[168] = 0,
206counter[169] = 0,
207counter[170] = 0,
208counter[171] = 0,
209counter[172] = 0,
210counter[173] = 0,
211counter[174] = 0,
212counter[175] = 0,
213counter[176] = 0,
214counter[177] = 0,
215counter[178] = 0,
216counter[179] = 0,
217counter[180] = 0,
218counter[181] = 0,
219counter[182] = 0,
220counter[183] = 0,
221counter[184] = 0,
222counter[185] = 0,
223counter[186] = 0,
224counter[187] = 0,
225counter[188] = 0,
226counter[189] = 0,
227counter[190] = 0,
228counter[191] = 0,
229counter[192] = 2035400,
230counter[193] = 0,
231counter[194] = 2035400,
232counter[195] = 0,
233counter[196] = 2,
234counter[197] = 0,
235counter[198] = 0,
236counter[199] = 0,
237counter[200] = 0,
238counter[201] = 0,
239counter[202] = 0,
240counter[203] = 0,
241counter[204] = 0,
242counter[205] = 0,
243counter[206] = 0,
244counter[207] = 0,
245counter[208] = 0,
246counter[209] = 0,
247counter[210] = 0,
248counter[211] = 0,
249counter[212] = 0,
250counter[213] = 0,
251counter[214] = 0,
252counter[215] = 0,
253counter[216] = 0,
254counter[217] = 0,
255counter[218] = 0,
256counter[219] = 0,
257counter[220] = 0,
258counter[221] = 0,
259counter[222] = 0,
260counter[223] = 0,
261counter[224] = 0,
262counter[225] = 0,
263counter[226] = 0,
264counter[227] = 0,
265counter[228] = 0,
266counter[229] = 0,
267counter[230] = 0,
268counter[231] = 0,
269counter[232] = 0,
270counter[233] = 0,
271counter[234] = 0,
272counter[235] = 0,
273counter[236] = 0,
274counter[237] = 0,
275counter[238] = 0,
276counter[239] = 0,
277counter[240] = 0,
278counter[241] = 0,
279counter[242] = 0,
280counter[243] = 0,
281counter[244] = 0,
282counter[245] = 0,
283counter[246] = 0,
284counter[247] = 0,
285counter[248] = 0,
286counter[249] = 0,
287counter[250] = 1901300,
288counter[251] = 0,
289counter[252] = 0,
290counter[253] = 0,
291counter[254] = 0,
292counter[255] = 0
293WHERE psid = 5;