<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>Andrea,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>The hardcoding in postgis.sql (I assume you mean the
populate...) was a mistake that we are planning to fix in a (micro or
rminor release). You can fix it in your copy if you want.
Generally speaking I tend to follow Stephen's approach because the installing
postgis in a non-public schema is not as tried and tested.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>I'm not even sure if there are any assumptions embedded in
products that support postgis we don't know that assume postgis is in
public.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>Aside from that -- there isn't any problem with that as long
as you add the postgis schema to your database search_path.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=392583322-03102009><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Andrea Peri<BR><B>Sent:</B> Saturday, October 03, 2009 12:09
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Install postgis on a different schema<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>I'm try-ing to install postgis (1.4) on a schema different
from 'public'.<BR>There is some documentation on this ?<BR><BR>I notice che
postgis.sql has some call on 'public' hardcoded,<BR>so I don't understand if is
necessary to install some objects of postgis on public .<BR><BR><BR>Many
thx,<BR><BR clear=all><BR>-- <BR>-----------------<BR>Andrea Peri<BR>. . . . . .
. . . <BR>qwerty אטלעש<BR>-----------------<BR><BR></BODY></HTML>