Excalibur blade, ext_contains locking issue
Posted in 2010
offdisc — — source: Usenet: comp.databases.informix
Hi All, We are using the Excalibur Text Search datablade, and are running into an error during Inserts. The error reads: "A select is in progress, so updating the index is not allowed". Now, the obvious answer is that a "Select for Update" cursor is locking the table, however I have been guaranteed that none of the programs use Update cursors. (I am new to this company, so I can only take their word for it) We do have many regular Selects that utilize the 'ext_contains' search from the datablade. Is it possible that ext_contains creates Locks on the Indexes? Thanks, Michael Hoffman DBA Colorado Secretary of State