fair enough, sounds like that should be no problem. I should also look up how to make a system schema in postgresql so that postgis system objects do not end up in my backups (or if this only a feature of pg_dump?), then how to make the new postgis schema a default search path in postgresql (so that i can still omit the schema name or search_path when calling the function).
<br><br>Still it seems to me that some of the people that make add-ons should talk to postgresql people to integrate their functions and other objects in a more comfortable manner.<br>Then again, maybe itīs just the way it is.
<br><br>WBL<br><br><div><span class="gmail_quote">On 5/15/07, <b class="gmail_sendername">David William Bitner</b> <<a href="mailto:david.bitner@gmail.com">david.bitner@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Install postgis into whatever schema you want and set the default search path in your postgresql configuration to use your postgis schema in the default search path. PostGIS is an add-on to PostgreSQL, as such there is no out-of-the-box schema other than public for it to use.
<div><span class="e" id="q_11291a58a6d81ba7_1"><br><br><div><span class="gmail_quote">On 5/15/07, <b class="gmail_sendername">Willy-Bas Loos</b> <<a href="mailto:willybas@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
willybas@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<span>>This is doable now, the main problem for newbies seems to be setting<br>>the search_path every single time so they have access to them.<br></span>That doesnīt seem logical to me: itīs also a problem for the same newbies to restore their PostGIS databases.
<br><br>It should be a default search_path, just like pg_catalog and public.<br>I dont need to set the search_path to use "select int2('25'::text)" either.<br>Or would that conflict with PostgreSQL policies?
<br><span><br>WBL</span><div><span><br><br><br><div><span class="gmail_quote">On 5/15/07, <b class="gmail_sendername">Paul Ramsey</b> <<a href="mailto:pramsey@refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
pramsey@refractions.net</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>On 15-May-07, at 4:33 AM, Willy-Bas Loos wrote:<br><br>> If you're changing alle the function names, maybe it's time to make<br>> system objects of them, stored in a seperate system schema (along<br>> with the types, operators, etc)?
<br><br>This is doable now, the main problem for newbies seems to be setting<br>the search_path every single time so they have access to them.<br><br>> Other than that it would be nice to add descriptions to the<br>> functions and operators in SQL,
e.g. to indicate what the input for<br>> each function should be when the number of arguments varies for<br>> functions with equal names.<br><br>How does one recover those descriptions at the commandline? Does \d<br>
functionname work?<br><br>P<br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
postgis-users@postgis.refractions.net</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br>
</span></div><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@postgis.refractions.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
postgis-users@postgis.refractions.net
</a><br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote></div><br><br clear="all"><br></span></div>-- <br>************************************<br><span class="sg">David William Bitner
</span><br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>
</blockquote></div><br>