search

segasai / q3c

PostgreSQL extension for spatial indexing on a sphere
GNU General Public License v2.0
76 stars 27 forks source link

Add instructions for upgrading to README.md? #27

Closed esabol closed 3 years ago

esabol commented 4 years ago

May I suggesting adding some instructions to README.md regarding how to upgrade an existing installation? It's really simple, but I think it's worth mentioning.

ALTER EXTENSION q3c UPDATE;

Or to a specific version:

ALTER EXTENSION q3c UPDATE TO '2.0.0';

This query is also useful:

SELECT * FROM pg_available_extension_versions WHERE name ='q3c';

Or maybe there there could be a make upgrade target in the Makefile which does make install and then does the ALTER EXTENSION q3c UPDATE; automatically?

segasai commented 4 years ago

Thanks. I've never got very comfortable with extensions and their versions. But yes I think the update instruction is useful. I wasn't aware myself of the 

SELECT * FROM pg_available_extension_versions WHERE name ='q3c';

query. I'll try to add something meaningful to the readme... (I'll keep the issue open in the mean time)

segasai commented 3 years ago

Fixed. Thanks for the suggestion.