Trigger commited problem - Mailing list pgsql-hackers

From Vlad Seryakov
Subject Trigger commited problem
Date
Msg-id 20010915162808.A7661@thread.crystalballinc.com
Whole thread Raw
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Rums Dabs
Date:
Subject: CD-RW Scheduled Database Backup...
Next
From: "Chris Boyle"
Date:
Subject: Re: NewYork Bombing: SQL server bomb proof!!