[pgrouting-users] Table location

[Dan Putler]

I decided I needed to clarify the point on the public schema being hard wired. What is really going on is that in a number of the pgRouting functions (implicitly) do not allow the use of other schemas since the code does not allow for the specification of a schema for a table. As a result, only tables in the public schema can be found by the functions.

Dan



--- On Thu, 1/27/11, Dan Putler <putler at yahoo.com> wrote:

From: Dan Putler <putler at yahoo.com>
Subject: Re: [pgrouting-users] Table location
To: "pgRouting users mailing list" <pgrouting-users at lists.osgeo.org>
Received: Thursday, January 27, 2011, 10:06 AM

I also found that I could only use pgrouting with a data table that are in the public schema. My memory is that in some of the functions (I know this is true for the shooting star algorithm), the public schema is "hard wired" within the code.

Dan

--- On Thu, 1/27/11, Daniel Kastl <daniel at georepublic.de> wrote:

From: Daniel Kastl <daniel at georepublic.de>
Subject: Re: [pgrouting-users] Table location
To: "pgRouting users mailing list" <pgrouting-users at lists.osgeo.org>
Received: Thursday, January 27, 2011, 8:18 AM

Good question, Ricardo!And thank you for sharing your experience, Henrik. 
I must admit I haven't tried it, and probably the
 majority of users always works in public schema.I added a ticket not to forget about this, because I think it would be nice to support the schema in all functions:

https://github.com/pgRouting/pgrouting/issues/issue/24


Daniel

2011/1/28 Henrik Berggren <henke.berggren at gmail.com>




  
    
    
  
  
    You can have it in other schemes but you need to run the
    assign_vertex_id in the public scheme, that is my experience.

    

    /H

    

    

    On 01/25/2011 10:42 PM, Ricardo Bayley wrote:
    Hi everyone,
      

      
      I am wondering, does pgrouting require to have tables on the
        public schema ? or could they be on any schema ?
      

      
      

      
      Thanks,
      

      
      

      
      Ricardo
      
_______________________________________________
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





-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de


Web: http://georepublic.de



-----Inline Attachment Follows-----

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


-----Inline Attachment Follows-----

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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110127/fe022b89/attachment.html