Re: Error that shouldn't happen?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, May 18, 2017 at 12:48 PM, Rob Brucks <rob.brucks@xxxxxxxxxxxxx> wrote:

I am unable to figure out how the trigger was able to successfully create the table, but then fail creating the index.  I would have expected one thread to "win" and create both the table and index, but other threads would fail when creating the table… but NOT when creating the index.

​I don't fully comprehend the locking involved here but if you want a failure while creating the table you shouldn't use "IF NOT EXISTS".  ​On the other side adding "IF NOT EXISTS" to the CREATE INDEX will supposedly prevent the error you are seeing.

The trigger that failed to create the index also failed to create the table - it just didn't care because of the IF NOT EXISTS.  At least this is what I am observing from your description.

David J.