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

2013-04-04 Thread Kaleeswaran Velu
ed...'; However it works now. Again thanks to Mr. Wolfe. Thanks and Regards Kaleeswaran Velu From: Wolfe Whalen To: Kaleeswaran Velu Cc: Postgres SQL List Sent: Thursday, April 4, 2013 12:58 PM Subject: Re: [SQL] Postgres trigger issue with update statem

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

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

2013-04-03 Thread Kaleeswaran Velu
 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 BEFORE INSERT OR UPDATE trigger attached in t