Received: from wombat.efone.com.au ([203.89.233.66]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0CMjxB14707 for ; Sat, 12 Jan 2002 17:46:03 -0500 (EST) (envelope-from murray@efone.com) Received: from efone.com ([202.138.193.106]) by wombat.efone.com.au (8.11.6/8.11.6) with ESMTP id g0CMiYQ14739; Sun, 13 Jan 2002 09:44:34 +1100 Message-ID: <3C40BE8F.4020201@efone.com> Date: Sun, 13 Jan 2002 09:54:07 +1100 From: Murray Prior Hobbs Organization: eFone International Pty Ltd User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2.1) Gecko/20010901 X-Accept-Language: en-us MIME-Version: 1.0 To: Tom Lane CC: pgsql-sql@postgresql.org Subject: Re: triggered data change violation References: <3C403CFD.5090004@efone.com> <6639.1010852389@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200201/106 X-Sequence-Number: 6195 i know this is a nieve question but if i get the following error "triggered data change violation in relation X" and i grep through every single file in the source tree for even just the word "violation" i expect to find it i desire to find it though i don't need to find it so any further help would be appreciated m ps i found it in the TODO docs - i read a lot of peoples banter on the subject of why it happens (and know that some might have been wrong in what causes it to happen - it seems only occures when the FK is composite) Tom Lane wrote: >Murray Prior Hobbs writes: > >>where on earth in the source do i find this error - >> > >If you're looking in development sources, you won't find it, >'cause it's gone. > >It used to lurk in commands/trigger.c. > > regards, tom lane >