Re: Any patch for delete and insert same row in a function (

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: MindTerm <mindterm(at)yahoo(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Any patch for delete and insert same row in a function (
Date: 2001-12-05 18:14:47
Message-ID: 20011205101322.D16316-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-12-05 18:16:36 Re: Any patch for delete and insert same row in a function ( transaction
Previous Message Tom Lane 2001-12-05 16:48:32 Re: Memory exhausted in AllocSetAlloc(269039)