Hi, PFA patch to fix the issue: Unable to create extension "postgis_topology" and "postgis_tiger_geocoder", due to wrong schema name in generated SQL query.
*For example*: It generates following query for '*postgis_toplology*' extension: CREATE EXTENSION *postgis_topology* SCHEMA *topology*; which is wrong. the correct query should be: CREATE EXTENSION *postgis_topology*; where it fetches '*topology*' schema from table *pg_available_extensions* and then sets schema when extension name is selected, but it should not set schema on name change. It is now fixed in this patch. Thanks Fahar for reporting. Please review and let me know for comments. Thanks, Surinder Kumar
unable_to_create_ext_with_postgis.patch
Description: Binary data
-- Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers