Re: [SQL] Problems with disabling triggers in Postgres 7.3.9

2006-03-09 Thread Flávio Suguimoto
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Huxton Sent: Thursday, March 09, 2006 11:42 AM To: Flávio Suguimoto Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Problems with disabling triggers in Postgres 7.3.9 Flávio Suguimoto wrote: > Hi Richard, > > I have that trigger ru

Re: [SQL] Problems with disabling triggers in Postgres 7.3.9

2006-03-09 Thread Flávio Suguimoto
r be called recursively. My question is there is another to do this trigger avoiding need to disable/enable the triggers? Or there is an way to solve this problem with RelationBuildTriggers? regards, Flávio Suguimoto -Original Message- From: Richard Huxton [mailto:[EMAIL PROTECTED] Se

Re: [SQL] Problems with disabling triggers in Postgres 7.3.9

2006-03-09 Thread Flávio Suguimoto
tself insert 3 more records in the participation table. If i don't disable the trigger it will be calling recursively... There is another walk-around to avoi it? regards, Flávio Suguimoto -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Alvaro He

[SQL] Problems with disabling triggers in Postgres 7.3.9

2006-03-09 Thread Flávio Suguimoto
Hi all, I have a problem in a trigger that disable all the triggers of a table. This error occurs randomly and my guess is that occurs when i have a lot of concurrents inserts in the table participation. The error is : RelationBuildTriggers: 2 record(s) not found for rel participation I search