<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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.<br><br>Dan<br><br><br><br>--- On <b>Thu, 1/27/11, Dan Putler <i><putler@yahoo.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Dan Putler <putler@yahoo.com><br>Subject: Re: [pgrouting-users] Table location<br>To: "pgRouting users mailing list" <pgrouting-users@lists.osgeo.org><br>Received: Thursday, January 27, 2011, 10:06 AM<br><br><div id="yiv2081062826"><table border="0" cellpadding="0"
cellspacing="0"><tbody><tr><td style="font: inherit;" valign="top">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.<br><br>Dan<br><br>--- On <b>Thu, 1/27/11, Daniel Kastl <i><daniel@georepublic.de></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Daniel Kastl <daniel@georepublic.de><br>Subject: Re: [pgrouting-users] Table location<br>To: "pgRouting users mailing list" <pgrouting-users@lists.osgeo.org><br>Received: Thursday, January 27, 2011, 8:18 AM<br><br><div id="yiv2081062826yiv1137965480">Good question, Ricardo!<div>And thank you for sharing your experience, Henrik. </div><div><br></div><div>I must admit I haven't tried it, and probably the
majority of users always works in public schema.</div><div>I added a ticket not to forget about this, because I think it would be nice to support the schema in all functions:</div>
<div><a rel="nofollow" target="_blank" href="https://github.com/pgRouting/pgrouting/issues/issue/24">https://github.com/pgRouting/pgrouting/issues/issue/24</a></div><div><br></div><div>
Daniel</div><div><br><br><div class="yiv2081062826yiv1137965480gmail_quote">2011/1/28 Henrik Berggren <span dir="ltr"><<a rel="nofollow">henke.berggren@gmail.com</a>></span><br><blockquote class="yiv2081062826yiv1137965480gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
You can have it in other schemes but you need to run the
assign_vertex_id in the public scheme, that is my experience.<br>
<br>
/H<div><div></div><div class="yiv2081062826yiv1137965480h5"><br>
<br>
<br>
On 01/25/2011 10:42 PM, Ricardo Bayley wrote:
</div></div><blockquote type="cite"><div><div></div><div class="yiv2081062826yiv1137965480h5">Hi everyone,
<div><br>
</div>
<div>I am wondering, does pgrouting require to have tables on the
public schema ? or could they be on any schema ?</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks,</div>
<div><br>
</div>
<div><br>
</div>
<div>Ricardo</div>
</div></div><pre><fieldset></fieldset><br>_______________________________________________<br>Pgrouting-users mailing list<br><a rel="nofollow">Pgrouting-users@lists.osgeo.org</a><br><a rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></pre>
</blockquote>
</div>
<br>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a rel="nofollow">Pgrouting-users@lists.osgeo.org</a><br>
<a rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><span style="font-family: arial,sans-serif; font-size: 13px; border-collapse: collapse;">Georepublic UG & Georepublic Japan<br>eMail: <a rel="nofollow" style="color: rgb(66, 99, 171);">daniel.kastl@georepublic.de</a><br>
Web: <a rel="nofollow" target="_blank" href="http://georepublic.de/" style="color: rgb(66, 99, 171);">http://georepublic.de</a></span><br>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="yiv2081062826plainMail">_______________________________________________<br>Pgrouting-users mailing list<br><a rel="nofollow">Pgrouting-users@lists.osgeo.org</a><br><a rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></div></blockquote></td></tr></tbody></table><br></div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Pgrouting-users mailing list<br><a ymailto="mailto:Pgrouting-users@lists.osgeo.org" href="/mc/compose?to=Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br></div></blockquote></td></tr></table><br>