31 |
static char *OutputValue(char *key, char *buf, int size); |
static char *OutputValue(char *key, char *buf, int size); |
32 |
|
|
33 |
#ifdef PG_FUNCTION_INFO_V1 |
#ifdef PG_FUNCTION_INFO_V1 |
34 |
Datum _rserv_log_(PG_FUNCTION_ARGS) |
Datum |
35 |
|
_rserv_log_(PG_FUNCTION_ARGS) |
36 |
#else |
#else |
37 |
HeapTuple _rserv_log_() |
HeapTuple |
38 |
|
_rserv_log_() |
39 |
#endif |
#endif |
40 |
{ |
{ |
41 |
Trigger *trigger; /* to get trigger name */ |
Trigger *trigger; /* to get trigger name */ |
42 |
int nargs; /* # of args specified in CREATE TRIGGER */ |
int nargs; /* # of args specified in CREATE TRIGGER */ |
43 |
char **args; /* argument: argnum */ |
char **args; /* argument: argnum */ |
44 |
Relation rel; /* triggered relation */ |
Relation rel; /* triggered relation */ |
45 |
HeapTuple tuple; /* tuple to return */ |
HeapTuple tuple; /* tuple to return */ |
46 |
HeapTuple newtuple = NULL; /* tuple to return */ |
HeapTuple newtuple = NULL; /* tuple to return */ |
47 |
TupleDesc tupdesc; /* tuple description */ |
TupleDesc tupdesc; /* tuple description */ |
48 |
int keynum; |
int keynum; |
49 |
char *key; |
char *key; |
50 |
char *okey; |
char *okey; |
51 |
char *newkey = NULL; |
char *newkey = NULL; |
52 |
int deleted, inserted, updated; |
int deleted, inserted, updated; |
53 |
char sql[8192]; |
char sql[8192]; |
54 |
char outbuf[8192]; |
char outbuf[8192]; |
55 |
char oidbuf[64]; |
char oidbuf[64]; |
56 |
int ret; |
int ret; |
57 |
|
|
58 |
/* Called by trigger manager ? */ |
/* Called by trigger manager ? */ |
59 |
if (!CurrentTriggerData) |
if (!CurrentTriggerData) |
60 |
elog(ERROR, "_rserv_log_: triggers are not initialized"); |
elog(ERROR, "_rserv_log_: triggers are not initialized"); |
61 |
|
|
62 |
/* Should be called for ROW trigger */ |
/* Should be called for ROW trigger */ |
63 |
if (TRIGGER_FIRED_FOR_STATEMENT(CurrentTriggerData->tg_event)) |
if (TRIGGER_FIRED_FOR_STATEMENT(CurrentTriggerData->tg_event)) |
64 |
elog(ERROR, "_rserv_log_: can't process STATEMENT events"); |
elog(ERROR, "_rserv_log_: can't process STATEMENT events"); |
65 |
|
|
66 |
tuple = CurrentTriggerData->tg_trigtuple; |
tuple = CurrentTriggerData->tg_trigtuple; |
67 |
|
|
68 |
trigger = CurrentTriggerData->tg_trigger; |
trigger = CurrentTriggerData->tg_trigger; |
69 |
nargs = trigger->tgnargs; |
nargs = trigger->tgnargs; |
70 |
args = trigger->tgargs; |
args = trigger->tgargs; |
71 |
|
|
72 |
if (nargs != 1) /* odd number of arguments! */ |
if (nargs != 1) /* odd number of arguments! */ |
73 |
elog(ERROR, "_rserv_log_: need in *one* argument"); |
elog(ERROR, "_rserv_log_: need in *one* argument"); |
74 |
|
|
75 |
keynum = atoi(args[0]); |
keynum = atoi(args[0]); |
76 |
|
|
77 |
if (keynum < 0 && keynum != ObjectIdAttributeNumber) |
if (keynum < 0 && keynum != ObjectIdAttributeNumber) |
78 |
elog(ERROR, "_rserv_log_: invalid keynum %d", keynum); |
elog(ERROR, "_rserv_log_: invalid keynum %d", keynum); |
79 |
|
|
80 |
rel = CurrentTriggerData->tg_relation; |
rel = CurrentTriggerData->tg_relation; |
81 |
tupdesc = rel->rd_att; |
tupdesc = rel->rd_att; |
82 |
|
|
83 |
deleted = (TRIGGER_FIRED_BY_DELETE(CurrentTriggerData->tg_event)) ? 1 : 0; |
deleted = (TRIGGER_FIRED_BY_DELETE(CurrentTriggerData->tg_event)) ? |
84 |
inserted = (TRIGGER_FIRED_BY_INSERT(CurrentTriggerData->tg_event)) ? 1 : 0; |
1 : 0; |
85 |
// updated = (TRIGGER_FIRED_BY_UPDATE(CurrentTriggerData->tg_event)) ? 1 : 0; |
|
86 |
|
inserted = (TRIGGER_FIRED_BY_INSERT(CurrentTriggerData->tg_event)) ? 1 : 0; |
87 |
updated = 0; |
|
88 |
if (TRIGGER_FIRED_BY_UPDATE(CurrentTriggerData->tg_event)) { |
updated = 0; |
89 |
updated = 1; |
if (TRIGGER_FIRED_BY_UPDATE(CurrentTriggerData->tg_event)) { |
90 |
newtuple = CurrentTriggerData->tg_newtuple; |
updated = 1; |
91 |
} |
newtuple = CurrentTriggerData->tg_newtuple; |
92 |
|
} |
93 |
|
|
94 |
#ifndef PG_FUNCTION_INFO_V1 |
#ifndef PG_FUNCTION_INFO_V1 |
95 |
|
|
96 |
/* |
/* |
97 |
* Setting CurrentTriggerData to NULL prevents direct calls to trigger |
* Setting CurrentTriggerData to NULL prevents direct calls to trigger |
98 |
* functions in queries. Normally, trigger functions have to be called |
* functions in queries. Normally, trigger functions have to be called |
99 |
* by trigger manager code only. |
* by trigger manager code only. |
100 |
*/ |
*/ |
101 |
CurrentTriggerData = NULL; |
CurrentTriggerData = NULL; |
102 |
#endif |
#endif |
|
|
|
|
/* Connect to SPI manager */ |
|
|
if ((ret = SPI_connect()) < 0) |
|
|
elog(ERROR, "_rserv_log_: SPI_connect returned %d", ret); |
|
|
|
|
|
if (keynum == ObjectIdAttributeNumber) { |
|
|
sprintf(oidbuf, "%u", tuple->t_data->t_oid); |
|
|
key = oidbuf; |
|
|
} else { |
|
|
key = SPI_getvalue(tuple, tupdesc, keynum); |
|
|
} |
|
|
|
|
|
if (key == NULL) |
|
|
elog(ERROR, "_rserv_log_: key must be not null"); |
|
|
|
|
|
if (newtuple && keynum != ObjectIdAttributeNumber) { |
|
|
newkey = SPI_getvalue(newtuple, tupdesc, keynum); |
|
|
if (newkey == NULL) |
|
|
elog(ERROR, "_rserv_log_: key must be not null"); |
|
|
if (strcmp(newkey, key) == 0) |
|
|
newkey = NULL; |
|
|
else |
|
|
deleted = 1; /* old key was deleted */ |
|
|
} |
|
|
|
|
|
if (strpbrk(key, "\\ \n'")) |
|
|
okey = OutputValue(key, outbuf, sizeof(outbuf)); |
|
|
else |
|
|
okey = key; |
|
|
|
|
|
|
|
|
/** |
|
|
versao onde verifica-se primeiro se o registro existe |
|
|
para decidir se faz insert ou update em _RSERV_LOG_ |
|
|
**********************/ |
|
|
|
|
|
#ifdef ASKFORUPDATE |
|
|
sprintf(sql, "SELECT true WHERE EXISTS (SELECT logid from _RSERV_LOG_ " |
|
|
"WHERE reloid = %u AND key = '%s')", |
|
|
rel->rd_id, okey); |
|
|
|
|
|
if (debug) |
|
|
elog(NOTICE, sql); |
|
|
|
|
|
if ((ret = SPI_exec(sql, 1)) < 0) { |
|
|
elog(ERROR, "_rserv_log_: SPI_exec(update) returned %d", ret); |
|
|
} |
|
|
|
|
|
if (SPI_processed > 0) { |
|
|
sprintf(sql, "update _RSERV_LOG_ set logid = %d, logtime = now(), " |
|
|
"insert = %d, update = %d, delete = %d where reloid = %u " |
|
|
"and key = '%s'", |
|
|
GetCurrentTransactionId(), |
|
|
inserted, updated, deleted, rel->rd_id, okey); |
|
|
|
|
|
if (debug) |
|
|
elog(NOTICE, sql); |
|
|
|
|
|
ret = SPI_exec(sql, 0); |
|
|
|
|
|
if (ret < 0) |
|
|
elog(ERROR, "_rserv_log_: SPI_exec(update) returned %d", ret); |
|
|
|
|
|
if (SPI_processed > 1) |
|
|
elog(ERROR, "_rserv_log_: duplicate tuples"); |
|
|
} else { |
|
|
sprintf(sql, "insert into _RSERV_LOG_ " |
|
|
"(reloid, logid, logtime, insert, update, delete, key) " |
|
|
"values (%u, %d, now(), %d, %d, %d, '%s')", |
|
|
rel->rd_id, GetCurrentTransactionId(), |
|
|
inserted, updated, deleted, okey); |
|
|
|
|
|
if (debug) |
|
|
elog(NOTICE, sql); |
|
|
|
|
|
ret = SPI_exec(sql, 0); |
|
|
|
|
|
if (ret < 0) |
|
|
elog(ERROR, "_rserv_log_: SPI_exec(insert) returned %d", ret); |
|
|
} |
|
103 |
|
|
104 |
#else |
/* Connect to SPI manager */ |
105 |
|
if ((ret = SPI_connect()) < 0) |
106 |
sprintf(sql, "update _RSERV_LOG_ set logid = %d, logtime = now(), " |
elog(ERROR, "_rserv_log_: SPI_connect returned %d", ret); |
107 |
"insert = %d, update = %d, delete = %d where reloid = %u " |
|
108 |
"and key = '%s'", |
if (keynum == ObjectIdAttributeNumber) |
109 |
GetCurrentTransactionId(), |
{ |
110 |
inserted, updated, deleted, rel->rd_id, okey); |
snprintf(oidbuf, sizeof(oidbuf), "%u", HeapTupleGetOid(tuple)); |
111 |
|
key = oidbuf; |
112 |
if (debug) |
} |
113 |
elog(NOTICE, sql); |
else |
114 |
|
key = SPI_getvalue(tuple, tupdesc, keynum); |
115 |
ret = SPI_exec(sql, 0); |
|
116 |
|
if (key == NULL) |
117 |
if (ret < 0) |
elog(ERROR, "_rserv_log_: key must be not null"); |
118 |
elog(ERROR, "_rserv_log_: SPI_exec(update) returned %d", ret); |
|
119 |
|
if (newtuple && keynum != ObjectIdAttributeNumber) |
120 |
|
{ |
121 |
/* |
newkey = SPI_getvalue(newtuple, tupdesc, keynum); |
122 |
* If no tuple was UPDATEd then do INSERT... |
if (newkey == NULL) |
123 |
*/ |
elog(ERROR, "_rserv_log_: key must be not null"); |
124 |
|
if (strcmp(newkey, key) == 0) |
125 |
|
newkey = NULL; |
126 |
if (SPI_processed > 1) |
else |
127 |
elog(ERROR, "_rserv_log_: duplicate tuples"); |
deleted = 1; /* old key was deleted */ |
128 |
else if (SPI_processed == 0) { |
} |
129 |
sprintf(sql, "insert into _RSERV_LOG_ " |
|
130 |
"(reloid, logid, logtime, insert, update, delete, key) " |
if (strpbrk(key, "\\ \n'")) |
131 |
"values (%u, %d, now(), %d, %d, %d, '%s')", |
okey = OutputValue(key, outbuf, sizeof(outbuf)); |
132 |
rel->rd_id, GetCurrentTransactionId(), |
else |
133 |
inserted, updated, deleted, okey); |
okey = key; |
134 |
|
|
135 |
if (debug) |
snprintf(sql, 8192, "update _RSERV_LOG_ set logid = %d, logtime = now(), " |
136 |
elog(NOTICE, sql); |
"insert = %d, update = %d, delete = %d where reloid = %u and key = '%s'", |
137 |
|
GetCurrentTransactionId(), inserted, updated, deleted, rel->rd_id, okey); |
138 |
ret = SPI_exec(sql, 0); |
|
139 |
|
if (debug) |
140 |
if (ret < 0) |
elog(DEBUG3, "sql: %s", sql); |
141 |
elog(ERROR, "_rserv_log_: SPI_exec(insert) returned %d", ret); |
|
142 |
} |
ret = SPI_exec(sql, 0); |
143 |
|
|
144 |
#endif |
if (ret < 0) |
145 |
|
elog(ERROR, "_rserv_log_: SPI_exec(update) returned %d", ret); |
146 |
if (okey != key && okey != outbuf) |
|
147 |
pfree(okey); |
/* |
148 |
|
* If no tuple was UPDATEd then do INSERT... |
149 |
if (newkey) { |
*/ |
150 |
if (strpbrk(newkey, "\\ \n'")) |
if (SPI_processed > 1) |
151 |
okey = OutputValue(newkey, outbuf, sizeof(outbuf)); |
elog(ERROR, "_rserv_log_: duplicate tuples"); |
152 |
else |
else if (SPI_processed == 0) |
153 |
okey = newkey; |
{ |
154 |
|
snprintf(sql, 8192, "insert into _RSERV_LOG_ " |
155 |
sprintf(sql, "insert into _RSERV_LOG_ " |
"(reloid, logid, logtime, insert, update, delete, key) " |
156 |
"(reloid, logid, logtime, insert, update, delete, key) " |
"values (%u, %d, now(), %d, %d, %d, '%s')", |
157 |
"values (%u, %d, now(), %d, %d, 0, '%s')", |
rel->rd_id, GetCurrentTransactionId(), |
158 |
rel->rd_id, GetCurrentTransactionId(), inserted, updated, okey); |
inserted, updated, deleted, okey); |
159 |
|
|
160 |
if (debug) |
if (debug) |
161 |
elog(NOTICE, sql); |
elog(DEBUG3, "sql: %s", sql); |
162 |
|
|
163 |
ret = SPI_exec(sql, 0); |
ret = SPI_exec(sql, 0); |
164 |
|
|
165 |
if (ret < 0) |
if (ret < 0) |
166 |
elog(ERROR, "_rserv_log_: SPI_exec returned %d", ret); |
elog(ERROR, "_rserv_log_: SPI_exec(insert) returned %d", ret); |
167 |
|
} |
168 |
if (okey != newkey && okey != outbuf) |
|
169 |
pfree(okey); |
if (okey != key && okey != outbuf) |
170 |
} |
pfree(okey); |
171 |
|
|
172 |
SPI_finish(); |
if (newkey) |
173 |
|
{ |
174 |
|
if (strpbrk(newkey, "\\ \n'")) |
175 |
|
okey = OutputValue(newkey, outbuf, sizeof(outbuf)); |
176 |
|
else |
177 |
|
okey = newkey; |
178 |
|
|
179 |
|
snprintf(sql, 8192, "insert into _RSERV_LOG_ " |
180 |
|
"(reloid, logid, logtime, insert, update, deleted, key) " |
181 |
|
"values (%u, %d, now(), %d, %d, 0, '%s')", |
182 |
|
rel->rd_id, GetCurrentTransactionId(), inserted, updated, okey); |
183 |
|
|
184 |
|
if (debug) |
185 |
|
elog(DEBUG3, "sql: %s", sql); |
186 |
|
|
187 |
|
ret = SPI_exec(sql, 0); |
188 |
|
|
189 |
|
if (ret < 0) |
190 |
|
elog(ERROR, "_rserv_log_: SPI_exec returned %d", ret); |
191 |
|
|
192 |
|
if (okey != newkey && okey != outbuf) |
193 |
|
pfree(okey); |
194 |
|
} |
195 |
|
|
196 |
|
SPI_finish(); |
197 |
|
|
198 |
#ifdef PG_FUNCTION_INFO_V1 |
#ifdef PG_FUNCTION_INFO_V1 |
199 |
return (PointerGetDatum(tuple)); |
return (PointerGetDatum(tuple)); |
200 |
#else |
#else |
201 |
return (tuple); |
return (tuple); |
202 |
#endif |
#endif |
203 |
} |
} |
204 |
|
|
225 |
buf[0] = 0; |
buf[0] = 0; |
226 |
for (xcnt = 0; xcnt < SerializableSnapshot->xcnt; xcnt++) |
for (xcnt = 0; xcnt < SerializableSnapshot->xcnt; xcnt++) |
227 |
{ |
{ |
228 |
sprintf(buf + strlen(buf), "%s%u", (xcnt) ? ", " : "", |
snprintf(buf + strlen(buf), 8192 - strlen(buf), |
229 |
SerializableSnapshot->xip[xcnt]); |
"%s%u", (xcnt) ? ", " : "", |
230 |
|
SerializableSnapshot->xip[xcnt]); |
231 |
} |
} |
232 |
|
|
233 |
if ((ret = SPI_connect()) < 0) |
if ((ret = SPI_connect()) < 0) |
234 |
elog(ERROR, "_rserv_sync_: SPI_connect returned %d", ret); |
elog(ERROR, "_rserv_sync_: SPI_connect returned %d", ret); |
235 |
|
|
236 |
sprintf(sql, "insert into _RSERV_SYNC_ " |
snprintf(sql, 8192, "insert into _RSERV_SYNC_ " |
237 |
"(server, syncid, synctime, status, minid, maxid, active) " |
"(server, syncid, synctime, status, minid, maxid, active) " |
238 |
"values (%u, currval('_rserv_sync_seq_'), now(), 0, %d, %d, '%s')", |
"values (%u, currval('_rserv_sync_seq_'), now(), 0, %d, %d, '%s')", |
239 |
server, SerializableSnapshot->xmin, SerializableSnapshot->xmax, active); |
server, SerializableSnapshot->xmin, SerializableSnapshot->xmax, active); |
240 |
|
|
241 |
ret = SPI_exec(sql, 0); |
ret = SPI_exec(sql, 0); |
242 |
|
|