Re: [Firebird-devel] Index unexpectedly deleted

[JoseMournho <dj_...@ya...>]

Why you inactivate all index except primary key on dependent tables?
Please could you tell me 
10x


Attila Román wrote:
> 
> I need to develop a replication modul and I have a problem. 
> 
> Engine: Firebird 1.5.2
> 
> Step of replication process:
> 
> 1. Start transaction (READ COMMITTED)
> 2. Inactive all triggers on dependent tables
> 3. Drop all foreign keys
> 4. Inactivate all index except primary key on dependent tables
> 5. Processing changes
> 6. Error at single update statement:
> 
> ISC ERROR CODE:335544382
> ISC ERROR MESSAGE: index unexpectedly deleted
> 
> Primary key exist on updated table. Originally foreign keys and indexes
> exists on updated table.
> 
> 7. Activate all indexes
> 8. Create all foreign keys
> 9. Activate all triggers
> 10. Commit transaction
> 
> What does it mean this error message? What is the reason? 
> Any comments or suggestions?
> 
> Thanks,
> Attila
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 
> 

-- 
View this message in context: http://www.nabble.com/Index-unexpectedly-deleted-tp1791152p23271797.html
Sent from the firebird-devel mailing list archive at Nabble.com.