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

pgRouting pgrouting-users
1

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

2

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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

3

Hi Steve,

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

Regards,
Csaba

···

On 20 February 2014 16:42, Stephen Woodbridge <woodbri@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@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–

Sándor Csaba
Tel: +3630/9605853
Fax: +3617002542