allow dropping index using exclusive lock. need for 9.1 support

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License

314 stars 48 forks source link

allow dropping index using exclusive lock. need for 9.1 support #2

Closed pavel-krush closed 4 years ago

pavel-krush commented 9 years ago

PostgreSQL 9.1 does not support DROP INDEX CONCURRENTLY. Usually this operation is fast enough so I added -e option to allow this tool to use DROP INDEX if server version is < 9.2