Trigger commited problem

From: Vlad Seryakov <vlad(at)crystalballinc(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Trigger commited problem
Date: 2001-09-15 20:28:08
Message-ID: 20010915162808.A7661@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Bryon Lape 2001-09-15 22:17:03 Re: NewYork Bombing: SQL server bomb proof!!
Previous Message peace_flower 2001-09-15 20:18:23 NewYork Bombing: SQL server bomb proof!!