Re: [SQL] Postgres trigger issue with update statement in it.

2013-04-04 Thread Kaleeswaran Velu
Hi Mr. Wolfe, Thanks for your response. I have received e-mails from several others. Thanks for everyone and appreciate your help. Mr. Wolfe sent a sample code. I took that as the base and debugged my code and identified the issue. Now my code is working fine. I have identified the real culprit

Re: [SQL] Postgres trigger issue with update statement in it.

2013-04-04 Thread Adrian Klaver
On 04/03/2013 09:08 PM, Kaleeswaran Velu wrote: Hello Friends, I am new to Postgres DB. Recently installed Postgres 9.2. Facing an issue with very simple trigger, tried to resolve myself by reading documents or google search but no luck. I have a table A(parent) and table B (child). There is a

Re: [SQL] Postgres trigger issue with update statement in it.

2013-04-04 Thread Wolfe Whalen
Hi Kaleeswaran, We're glad to have you on the mailing list. I don't know enough about your trigger function to know exactly where it's going wrong, but I threw together a quick example that has an insert trigger on a child table that updates a row on the parent table. I'm hoping this might hel