sqlalchemy-bot

**Aurélien Campéas ([@auc](https://github.com/auc)) wrote:** > congrats on your participation in basic probability :) Isn't that cool ? :o Though I'd have written long name handling like in my monkeypatch, from...

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** actual "None" is already meaningful if you have a naming convention in place, it means, "use the naming convention". if you pass an empty naming convention...

**Aurélien Campéas ([@auc](https://github.com/auc)) wrote:** I've discovered another quite unsettling thing related to this. When I want to drop such tables and then recreate them I'm forbidden to do this by...

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** the patches are only here in the bitbucket comments above, you can try cutting-and-pasting from there. to identify this new PG sitaution, you can share with...

**Aurélien Campéas ([@auc](https://github.com/auc)) wrote:** Ok I've put the patch as a real thing on top of 1.3.x. I'll try it asap. Now the failure transcript (the real things start ~2018-07-06...

**Aurélien Campéas ([@auc](https://github.com/auc)) wrote:** And I confirm that the patch (just like previously my hand-coded query) does make it work.

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** you said something about an all-new problem and a "stale" index, is that above? I only see the error we already are dealing with in this...

**Aurélien Campéas ([@auc](https://github.com/auc)) wrote:** Hmm. Reading very slowly again I see this: ``` 2018-07-06 17:08:31,909 INFO sqlalchemy.engine.base.Engine CREATE INDEX ix_tsh_snapshot_deleteme_parent ON "tsh.snapshot".deleteme (parent) 2018-07-06 17:08:31,909 INFO sqlalchemy.engine.base.Engine {} 2018-07-06 17:08:31,910...

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** I don't see evidence that the index isn't being dropped?

**Michael Bayer ([@zzzeek](https://github.com/zzzeek)) wrote:** right, whatever you are doing is making SA create the index twice. things like adding the same index to the table twice perhaps, or making two...