<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#ffffff" text="#000000">
    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 cite="mid:52434.96926.qm@web161915.mail.bf1.yahoo.com"
      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 class="moz-txt-link-rfc2396E" href="mailto:daniel@georepublic.de">&lt;daniel@georepublic.de&gt;</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 class="moz-txt-link-rfc2396E" href="mailto:daniel@georepublic.de">&lt;daniel@georepublic.de&gt;</a><br>
                Subject: Re: [pgrouting-users] Table location<br>
                To: "pgRouting users mailing list"
                <a class="moz-txt-link-rfc2396E" href="mailto:pgrouting-users@lists.osgeo.org">&lt;pgrouting-users@lists.osgeo.org&gt;</a><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.&nbsp;</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&nbsp;schema&nbsp;in all functions:</div>
                  <div><a moz-do-not-send="true" 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">&lt;<a
                          moz-do-not-send="true" rel="nofollow"
                          ymailto="mailto:henke.berggren@gmail.com"
                          target="_blank"
                          href="/mc/compose?to=henke.berggren@gmail.com">henke.berggren@gmail.com</a>&gt;</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 class="yiv1137965480h5"><br>
                              <br>
                              <br>
                              On 01/25/2011 10:42 PM, Ricardo Bayley
                              wrote: </div>
                          </div>
                          <blockquote type="cite">
                            <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>
_______________________________________________
Pgrouting-users mailing list
<a moz-do-not-send="true" 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>
<a moz-do-not-send="true" rel="nofollow" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
                          </blockquote>
                        </div>
                        <br>
                        _______________________________________________<br>
                        Pgrouting-users mailing list<br>
                        <a moz-do-not-send="true" 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 moz-do-not-send="true" 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 &amp; Georepublic Japan<br>
                      eMail:&nbsp;<a moz-do-not-send="true" 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:&nbsp;<a moz-do-not-send="true" 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 moz-do-not-send="true"
                    ymailto="mailto:Pgrouting-users@lists.osgeo.org"
                    href="/mc/compose?to=Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
                  <a moz-do-not-send="true"
                    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>
        </tbody>
      </table>
      <br>
      <pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Pgrouting-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
</pre>
    </blockquote>
  </body>
</html>