[pgrouting-users] install issue in a schema other than public

Sandor Csaba sandor.csaba at viamap.hu
Thu Feb 20 07:28:03 PST 2014


Hi list,

I want to install postgis and pgrouting into a schema named gis.

valami=# create schema gis;
CREATE SCHEMA
valami=# create extension postgis schema gis;
CREATE EXTENSION
valami=# create extension pgrouting schema gis;
ERROR:  function pgr_iscolumnindexed(text, text) does not exist
valami=#

If I try the public schema it works:
valami=# create extension pgrouting;
CREATE EXTENSION
valami=#

Any idea why is this happening?

Thanks a lot,
Csaba

Ubuntu Server 12.04
Postgresql-9.3, Postgis-2.1
Pgrouting 2.0 built from source

-- 
Sándor Csaba
Tel: +3630/9605853
Fax: +3617002542
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20140220/f80d4ec4/attachment.html>


More information about the Pgrouting-users mailing list