You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The command : SELECT audit.audit_table('rolls');
completed with no errors. However, when I insert a new row, with pgAdmin III, into the 'rolls' table I get the following error :-
An error has occurred:
ERROR: function hstore(vault_scanning.rolls) does not exist
LINE 1: SELECT hstore(NEW.) - excluded_cols
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT hstore(NEW.) - excluded_cols
CONTEXT: PL/pgSQL function audit.if_modified_func() line 49 at assignment
OK
The text was updated successfully, but these errors were encountered:
The following code resolved the issue !!!!! :)
....
ELSIF (TG_OP = 'INSERT' AND TG_LEVEL = 'ROW') THEN
select into audit_row.row_data hstore(new) - excluded_cols;
....
Postgresql vers.: 9.4
Table: vault_scanning.rolls
The command : SELECT audit.audit_table('rolls');
completed with no errors. However, when I insert a new row, with pgAdmin III, into the 'rolls' table I get the following error :-
An error has occurred:
ERROR: function hstore(vault_scanning.rolls) does not exist
LINE 1: SELECT hstore(NEW.) - excluded_cols
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
QUERY: SELECT hstore(NEW.) - excluded_cols
CONTEXT: PL/pgSQL function audit.if_modified_func() line 49 at assignment
OK
The text was updated successfully, but these errors were encountered: