Re: List of error messages
От | Gisle Dankel |
---|---|
Тема | Re: List of error messages |
Дата | |
Msg-id | Pine.SO4.4.04.10009141307050.6576-100000@onion обсуждение исходный текст |
Ответ на | Re: List of error messages (Jan Wieck <janwieck@Yahoo.com>) |
Список | pgsql-general |
Hi Jan, > Gisle Dankel wrote: > > > > Hi, > > I couldn't find any explanations of error messages in the docs. > > > > I get this error message: > > ERROR: triggered data change violation on relation "22" > > > > after doing > > > > DELETE FROM "22" WHERE id = 36; > > > > There's no foreign keys referring to this table, nor any triggers that I > > have explicitly defined. > > This occurs inside a transaction. When I tried it outside the transaction > > it worked fine! > > > > Anyone got any idea of what is going on? > > Do you need more information? > > Maybe this table is the referring one in a foreign key > relationship? > > Triggers/foreign keys are the only things that can cause the > above error message. It is a requirement of the SQL99 specs > that one and the same row, that is part of referential > integrity constraints or triggers, cannot be touched twice > during a transaction. > > So if you did (in the same transaction) > > UPDATE "22" SET "22 A)" = 2.2 WHERE id = 36; > > then the above DELETE might be forbidden as of the specs. > > Yes, that's it ! The element was inserted in the same transaction. I'll have to remove the foreign key constraints. Cheers, Gisle
В списке pgsql-general по дате отправления: