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

Stephen Woodbridge woodbri at swoodbridge.com
Thu Feb 20 07:42:41 PST 2014

Hi Sandor,

Sorry this was a minor bug in the release. It is easy to fix on your 
system. Locate the pgrouting--2.0.0.sql file in your extensions 
directory and edit it. Search for "public." should bring you to line:

CREATE OR REPLACE FUNCTION public.pgr_isColumnIndexed(tab text, col text)

and remove the "public." and save the file. The in your database:

CREATE EXTENSION pgrouting schema gis;

And you should be good to go. THis has been fixed in the develop branch 
for the next release.


On 2/20/2014 10:28 AM, Sandor Csaba wrote:
> Hi list,
> I want to install postgis and pgrouting into a schema named gis.
> valami=# create schema gis;
> valami=# create extension postgis schema gis;
> 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;
> 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
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

More information about the Pgrouting-users mailing list