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

[Sandor Csaba]

Hi Steve,

Many thanks for this! It works of course. :)

Regards,
Csaba


On 20 February 2014 16:42, Stephen Woodbridge <woodbri at swoodbridge.com>wrote:

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



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