<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Given your comment on vertex assignments needing to be done in the public schema, I'm now not sure. I may have had a problem with the vertex assignments, looked through that code and discovered that it didn't handle anything other than the public schema well, and just put everything in public after that. I did this in July, so things are on the hazy side. What I was working on isn't part of a web application, and I am behind a firewall, so I was safe in keeping everything in the public schema.<br><br>Dan<br><br><br>--- On <b>Thu, 1/27/11, Henrik Berggren <i><henke.berggren@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Henrik Berggren <henke.berggren@gmail.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:26 AM<br><br><div id="yiv345539982">
Are you sure about that the data needs to be in the public schema
for shooting_star to work properly? <br>
<br>
/Henrik <br>
<br>
On 01/27/2011 07:06 PM, Dan Putler wrote:
<blockquote type="cite">
<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><a rel="nofollow" class="yiv345539982moz-txt-link-rfc2396E" ymailto="mailto:daniel@georepublic.de" target="_blank" href="/mc/compose?to=daniel@georepublic.de"><daniel@georepublic.de></a></i></b>
wrote:<br>
<blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>
From: Daniel Kastl <a rel="nofollow" class="yiv345539982moz-txt-link-rfc2396E" ymailto="mailto:daniel@georepublic.de" target="_blank" href="/mc/compose?to=daniel@georepublic.de"><daniel@georepublic.de></a><br>
Subject: Re: [pgrouting-users] Table location<br>
To: "pgRouting users mailing list"
<a rel="nofollow" class="yiv345539982moz-txt-link-rfc2396E" 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>
Received: Thursday, January 27, 2011, 8:18 AM<br>
<br>
<div id="yiv345539982yiv1137965480">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="yiv345539982yiv1137965480gmail_quote">2011/1/28
Henrik Berggren <span dir="ltr"><<a rel="nofollow">henke.berggren@gmail.com</a>></span><br>
<blockquote class="yiv345539982yiv1137965480gmail_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 class="yiv345539982yiv1137965480h5"><br>
<br>
<br>
On 01/25/2011 10:42 PM, Ricardo Bayley
wrote: </div>
</div>
<blockquote type="cite">
<div>
<div class="yiv345539982yiv1137965480h5">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="yiv345539982plainMail">_______________________________________________<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>
<pre><fieldset class="yiv345539982mimeAttachmentHeader"></fieldset><br>_______________________________________________<br>Pgrouting-users mailing list<br><a rel="nofollow" class="yiv345539982moz-txt-link-abbreviated" 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" class="yiv345539982moz-txt-link-freetext" 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>-----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>