Trying to update a user also blows up after this change:
ERROR: type of parameter 39 (date) does not match that when preparing the plan (timestamp with time zone) CONTEXT: SQL statement "INSERT INTO auditor.actor_usr_history ( audit_id, audit_time, audit_action, audit_user, audit_ws, id, card, profile, usrname, email, passwd, standing, ident_type, ident_value, ident_type2, ident_value2, net_access_level, photo_url, prefix, first_given_name, second_given_name, family_name, suffix, alias, day_phone, evening_phone, other_phone, mailing_address, billing_address, home_ou, dob, active, master_account, super_user, barred, deleted, juvenile, usrgroup, claims_returned_count, credit_forward_balance, last_xact_id, alert_message, create_date, expire_date, claims_never_checked_out_count, last_update_time ) SELECT nextval('auditor.actor_usr_pkey_seq'), now(), SUBSTR(TG_OP,1,1), eg_user, eg_ws, OLD.id, OLD.card, OLD.profile, OLD.usrname, OLD.email, OLD.passwd, OLD.standing, OLD.ident_type, OLD.ident_value, OLD.ident_type2, OLD.ident_value2, OLD.net_access_level, OLD.photo_url, OLD.prefix, OLD.first_given_name, OLD.second_given_name, OLD.family_name, OLD.suffix, OLD.alias, OLD.day_phone, OLD.evening_phone, OLD.other_phone, OLD.mailing_address, OLD.billing_address, OLD.home_ou, OLD.dob, OLD.active, OLD.master_account, OLD.super_user, OLD.barred, OLD.deleted, OLD.juvenile, OLD.usrgroup, OLD.claims_returned_count, OLD.credit_forward_balance, OLD.last_xact_id, OLD.alert_message, OLD.create_date, OLD.expire_date, OLD.claims_never_checked_out_count, OLD.last_update_time FROM auditor.get_audit_info()" PL/pgSQL function "audit_actor_usr_func" line 3 at SQL statement SQL statement "UPDATE actor.usr SET profile = 2 WHERE id = usr_id AND profile = 22" PL/pgSQL function "mvlc_remove_privilege" line 29 at SQL statement
Trying to update a user also blows up after this change:
ERROR: type of parameter 39 (date) does not match that when preparing the plan (timestamp with time zone) actor_usr_ history ( audit_id, audit_time, audit_action, audit_user, audit_ws, id, card, profile, usrname, email, passwd, standing, ident_type, ident_value, ident_type2, ident_value2, net_access_level, photo_url, prefix, first_given_name, second_given_name, family_name, suffix, alias, day_phone, evening_phone, other_phone, mailing_address, billing_address, home_ou, dob, active, master_account, super_user, barred, deleted, juvenile, usrgroup, claims_ returned_ count, credit_ forward_ balance, last_xact_id, alert_message, create_date, expire_date, claims_ never_checked_ out_count, last_update_time )
SELECT nextval( 'auditor. actor_usr_ pkey_seq' ),
now( ),
SUBSTR( TG_OP,1, 1),
eg_ user,
eg_ ws,
OLD. id, OLD.card, OLD.profile, OLD.usrname, OLD.email, OLD.passwd, OLD.standing, OLD.ident_type, OLD.ident_value, OLD.ident_type2, OLD.ident_value2, OLD.net_ access_ level, OLD.photo_url, OLD.prefix, OLD.first_ given_name, OLD.second_ given_name, OLD.family_name, OLD.suffix, OLD.alias, OLD.day_phone, OLD.evening_phone, OLD.other_phone, OLD.mailing_ address, OLD.billing_ address, OLD.home_ou, OLD.dob, OLD.active, OLD.master_account, OLD.super_user, OLD.barred, OLD.deleted, OLD.juvenile, OLD.usrgroup, OLD.claims_ returned_ count, OLD.credit_ forward_ balance, OLD.last_xact_id, OLD.alert_message, OLD.create_date, OLD.expire_date, OLD.claims_ never_checked_ out_count, OLD.last_ update_ time
FROM auditor. get_audit_ info()" actor_usr_ func" line 3 at SQL statement privilege" line 29 at SQL statement
CONTEXT: SQL statement "INSERT INTO auditor.
PL/pgSQL function "audit_
SQL statement "UPDATE actor.usr
SET profile = 2
WHERE id = usr_id
AND profile = 22"
PL/pgSQL function "mvlc_remove_