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
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
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