<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">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="yiv1137965480">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="yiv1137965480gmail_quote">2011/1/28 Henrik Berggren <span dir="ltr"><<a rel="nofollow" ymailto="mailto:henke.berggren@gmail.com" target="_blank" href="/mc/compose?to=henke.berggren@gmail.com">henke.berggren@gmail.com</a>></span><br><blockquote class="yiv1137965480gmail_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="yiv1137965480h5"><br>
<br>
<br>
On 01/25/2011 10:42 PM, Ricardo Bayley wrote:
</div></div><blockquote type="cite"><div><div></div><div class="yiv1137965480h5">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" ymailto="mailto:Pgrouting-users@lists.osgeo.org" target="_blank" href="/mc/compose?to=Pgrouting-users@lists.osgeo.org">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" ymailto="mailto:Pgrouting-users@lists.osgeo.org" target="_blank" href="/mc/compose?to=Pgrouting-users@lists.osgeo.org">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" ymailto="mailto:daniel.kastl@georepublic.de" target="_blank" href="/mc/compose?to=daniel.kastl@georepublic.de" 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="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>