I made a fork of the pgrouting proyect to modify the functions so that schemas can be used:
for table: streets in current_schema
vertices_tmp will become current_schema.steets_vertices
for table: schema.streets
vertices_tmp will become schema.steets_vertices
I will modify as needed the sql files in common and create some new functions that are needed for handling the schemas.
Once I finish, I will post the changes so they can be tested by anyone.
https://github.com/cvvergara/pgrouting/tree/develop
I created a pull request for the schema handling problem. Issue 178
Can you give it a try and report any problems?
It has a lot of NOTICES to inform the status of the process, to help pin point any problem you encounter.
On 8/23/2013 12:48 PM, Vicky Vergara wrote:
<https://github.com/cvvergara/pgrouting/tree/develop><https://github.com/cvvergara/pgrouting/tree/develop>https://github.com/cvvergara/pgrouting/tree/develop
I created a pull request for the schema handling problem. Issue 178
Can you give it a try and report any problems?
It has a lot of NOTICES to inform the status of the process, to help
pin point any problem you encounter.
<https://github.com/cvvergara/pgrouting/tree/develop>
I have created a branch in pgrouting cvvergara-issue178 where I merged vivky's pull request and fixed a few minor problems. It might be easier for most users to:
From the pgrouting directory:
git pull
git checkout cvvergara-issue178
And work this that code to test her changes.
-Steve