Triggered data change violation

From: Peter Vazsonyi <neko(at)sun2(dot)szif(dot)hu>
To: PgSql General List <pgsql-general(at)postgresql(dot)org>
Subject: Triggered data change violation
Date: 2001-03-02 09:32:08
Message-ID: Pine.LNX.4.10.10103021009020.2147-100000@sun2.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I have a table, with an update trigger (it change the value of
'last_modify' field to current timestamp)
Sometimes if i try delete rows in this table (before delete, there are some
inserts after a 'begin') i get this change violation error. I don't now
why.
Can somebody help me?

Thank's
--
nek.

(postgresql 7.0.2)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2001-03-02 11:38:23 Re: showing rules/triggers with psql
Previous Message Renaud Tthonnart 2001-03-02 08:16:47 Re: Counting elements of an array