Received: from web20201.mail.yahoo.com (web20201.mail.yahoo.com [216.136.226.56]) by postgresql.org (8.11.3/8.11.4) with SMTP id fB5Ab2m69225 for ; Wed, 5 Dec 2001 05:37:02 -0500 (EST) (envelope-from mindterm@yahoo.com) Message-ID: <20011205103703.71878.qmail@web20201.mail.yahoo.com> Received: from [203.85.100.3] by web20201.mail.yahoo.com via HTTP; Wed, 05 Dec 2001 02:37:03 PST Date: Wed, 5 Dec 2001 02:37:03 -0800 (PST) From: MindTerm Subject: Any patch for delete and insert same row in a function ( transaction ) To: pgsql-sql@postgresql.org In-Reply-To: <6517.1007505797@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/44 X-Sequence-Number: 5867 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 ? Thx. M.T. __________________________________________________ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com