Programmatic Trigger Create

2021-03-20 Thread Niko Ware
I would like to programmatically create audit trail functions which are called by triggers for custom user tables. This will be used for audit trail generation in our application. The user is able to define a custom table. Therefore, I need a custom audit trail function. The audit trail function ou

sql3types.h does not include "BigInt"

2021-03-15 Thread Niko Ware
I'm using "dynamic sql" to process generic queries (see code fragment below). The routine works correctly for most data types, but it does not work for functions (e.g., NextVal()). The data TYPE returned for NextVal() sequence is zero (see line 24 of the code fragment). The documented data type for

Example 31-2. libpq Example Program 2

2021-03-10 Thread Niko Ware
I need notifications to a C application on inserts to a table. The notification funcion is listed below. My program and "Example 31-2. libpq Example Program 2" receive the notification, but the payload message in "PGnotify *notify->extra" is invalid. The example code is located here: https://www.p