5
EXEC SQL INCLUDE ../regression;
7
int main(int argc, char* argv[]) {
8
EXEC SQL char text[25];
11
EXEC SQL CONNECT TO REGRESSDB1;
13
EXEC SQL SET AUTOCOMMIT TO ON;
14
EXEC SQL WHENEVER SQLWARNING SQLPRINT;
15
EXEC SQL WHENEVER SQLERROR SQLPRINT;
17
EXEC SQL CREATE TABLE My_Table ( Item1 int, Item2 text );
18
EXEC SQL CREATE TABLE Log (name text, w text);
20
EXEC SQL CREATE FUNCTION My_Table_Check() RETURNS trigger
23
INSERT INTO Log VALUES(TG_NAME, TG_WHEN);
28
EXEC SQL CREATE TRIGGER My_Table_Check_Trigger
32
EXECUTE PROCEDURE My_Table_Check();
34
EXEC SQL INSERT INTO My_Table VALUES (1234, 'Some random text');
35
EXEC SQL INSERT INTO My_Table VALUES (5678, 'The Quick Brown');
36
EXEC SQL SELECT name INTO :text FROM Log LIMIT 1;
37
printf("Trigger %s fired.\n", text);
39
EXEC SQL DROP TRIGGER My_Table_Check_Trigger ON My_Table;
40
EXEC SQL DROP FUNCTION My_Table_Check();
41
EXEC SQL DROP TABLE Log;
42
EXEC SQL DROP TABLE My_Table;
44
EXEC SQL DISCONNECT ALL;