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

[Stephen Woodbridge]

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:

DROP EXTENSION pgrouting;
CREATE EXTENSION pgrouting schema gis;

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

Thanks,
   -Steve


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;
> 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
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>