Thanks Richard, Until the last version of my application i couldn't know which record is different of another. But i saw that someone created a new column and i guess that i could know if its the first one or ther other 3...
Thank you very much... -----Original Message----- From: [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 running on AFTER INSERT of participation table. That > trigger inserts 3 new record for each line i inserted in participation. Yes, but WHY? What problem are you trying to solve. Presumably there is some difference between the first "participation" row and the other 3 - the status, the ticket-number, something. Test for that difference and you'll know whether you'll need to insert those 3 extra rows or not. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
