Error on insert manyToMany when a postgres trigger is execute on table after insert event

[matlow]

Hello,

I hope you could help. I want to log some operation in postgres database with trigger function and implement auditing function like this one https://www.postgresql.org/docs/current/plpgsql-trigger.html

There is my problem :

I have 2 entities : entityA which has a many to many relationship with entity B with join table named "tableA_tableB"
When i persist new entity A, a new entity B is also persisted.

But i got an error if i had a postgresql trigger function on tableA to log insert operation.

detail 'An exception occurred while executing a query: SQLSTATE[23503]: Foreign key violation: 7 ERROR: insert or update on table "tableA_tableB" violates foreign key constraint "fk_d3b752a277570a4c"\nDETAIL: Key (tableA_id)=(18) is not present in table "tableA".'

There is the postgresql trigger :

create or replace function tableA_ait() returns trigger 
set schema 'public' language plpgsql as $$
begin
 	insert into log_audit (log_data, log_table, operation) values (row_to_json(new.*), 'tableA', TG_OP);	
 	return null;
end;
$$;

create trigger tableA_ait after insert on tableA
for each statement execute procedure tableA_ait();

TableA and tableB use serial type on primary key.

Could you help me to know why the ManyToManyPersister launch this exception ?

Thx

[matlow]

issue here #11805