Anyone know what causes this? Dropping an index errors out because it's part of a constraint, only it isn't really.
drop index PROBE_NAME; Index "PROBE_NAME" belongs to a constraint; SQL statement: drop index PROBE_NAME [90085-171]<http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> 90085/90085 (Help)<http://h2database.com/javadoc/org/h2/constant/ErrorCode.html#c90085> SELECT * FROM INFORMATION_SCHEMA.CONSTRAINTS WHERE UNIQUE_INDEX_NAME = 'PROBE_NAME'; CONSTRAINT_CATALOG <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> CONSTRAINT_SCHEMA <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> CONSTRAINT_NAME <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> CONSTRAINT_TYPE <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> TABLE_CATALOG <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> TABLE_SCHEMA <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> TABLE_NAME <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> UNIQUE_INDEX_NAME <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> CHECK_EXPRESSION <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> COLUMN_LIST <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> REMARKS <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> SQL <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#> ID <http://grotto:8082/query.do?jsessionid=5b027ab3b7bc75cecaf337fcc005de61#>(no rows, 1 ms) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
