Guys,
New to Postgres - here's my code inside an event trigger:ELSIF (TG_OP = 'INSERT') THEN
EXECUTE format('INSERT INTO %I SELECT statement_timestamp(), ''INSERT'', $1.*', TG_TABLE_NAME || '_cdc')
USING NEW;
RETURN NEW;
ERROR: invalid input syntax for integer: "INSERT"
LINE 1: ...T INTO listings_cdc SELECT statement_timestamp(), 'INSERT', ...
^
QUERY: INSERT INTO listings_cdc SELECT statement_timestamp(), 'INSERT', $1.*
CONTEXT: PL/pgSQL function audit_func() line 28 at EXECUTE
LINE 1: ...T INTO listings_cdc SELECT statement_timestamp(), 'INSERT', ...
^
QUERY: INSERT INTO listings_cdc SELECT statement_timestamp(), 'INSERT', $1.*
CONTEXT: PL/pgSQL function audit_func() line 28 at EXECUTE