Received: from megazone.bigpanda.com ([63.150.15.178]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fB5IElm88282 for ; Wed, 5 Dec 2001 13:14:47 -0500 (EST) (envelope-from sszabo@megazone23.bigpanda.com) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 38DE8D5E9; Wed, 5 Dec 2001 10:14:47 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 2C7C25BEA; Wed, 5 Dec 2001 10:14:47 -0800 (PST) Date: Wed, 5 Dec 2001 10:14:47 -0800 (PST) From: Stephan Szabo To: MindTerm Cc: Subject: Re: Any patch for delete and insert same row in a function ( In-Reply-To: <20011205103703.71878.qmail@web20201.mail.yahoo.com> Message-ID: <20011205101322.D16316-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200112/50 X-Sequence-Number: 5873 On Wed, 5 Dec 2001, MindTerm wrote: > Hi all, > > Postgresql shows error message > "triggered data change violation on relation" > when trying to insert and delete same row ( same > primary key ) with in a function or transaction. > > Does any solution available to solve this problem ? This check has been taken out for 7.2. In the meantime you can probably just comment out the lines that do the error in backend/commands/trigger.c