Update README to name the q3c index

segasai / q3c

PostgreSQL extension for spatial indexing on a sphere

GNU General Public License v2.0

76 stars 27 forks source link

Update README to name the q3c index #10

Closed andycasey closed 7 years ago

andycasey commented 7 years ago

Otherwise -- at least in psql 9.5 -- the default index name is mytable_q3c_ang2ipix_idx and CLUSTER q3c_mytable_idx ON mytable will fail because the index name q3c_mytable_idx doesn't exist.

segasai commented 7 years ago

Thanks, Andy, I've fixed the issue in e320f5b4e0502fb44860778bd0b4fed7e54b0f3b however I did it by changing the name of the index in the CLUSTER command instead.