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;