Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DEFERRABLE check constraint on IOT not working?

Re: DEFERRABLE check constraint on IOT not working?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 5 Mar 2006 07:13:08 +0100
Message-ID: <440a8173$0$21545$626a54ce@news.free.fr>

"Gabor" <gabor.kecskemeti_at_yahoo.com> a écrit dans le message de news: 1141515561.483143.203740_at_i39g2000cwa.googlegroups.com...
|I don't think it's because delete doesn't "realy" deletes the row, or
| not just that. Try the same with UPDATE instead of DELETE (update "a"
| to correct > 0 value), the same error happens..
|
| Anyway, I can't raise a TAR, because I'm not a customer (as you can
| see, I use 10gXE). Or is there way for XE users to report bugs too?
|

Update in an index (or IOT) is not really an update but delette+insert. So you're in the same problem.

Regards
Michel Cadot Received on Sun Mar 05 2006 - 00:13:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US