Hannes Dorbath wrote:
ERROR: relation "ts_test_tsv" already exists test=# drop INDEX ts_test_tsv ; DROP INDEX
This is a general thing I'd like to ask. If the creation of an index fails, why is it nevertheless there? No matter if deadlock or my GIN error, why isn't the whole operation "rolled back"? And what state is it it leaves me on? Do I end up with a corrupt index on my table?
-- Best regards, Hannes Dorbath ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
