Обсуждение: Trigger commited problem

Поиск
Список
Период
Сортировка

Trigger commited problem

От
Vlad Seryakov
Дата:
Hello,
I have strange problem with seeing uncommited changes that were made inside trigger.

i have function func1 that inserts one record into table tab1.
There is after trigger on that table tab1 which in turns 
inserts several records in another table tab2.
Then in func1 i am trying to access new records from table 
tab2 and i get nothing. I do not see these records.
Is it documented behaviour, i couldn't find anything in docs.

Thanks