<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2>Yes andy</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2> a) /usr/local/lib was already present in
/etc/ld.so.conf</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008> <FONT
face=Arial color=#0000ff size=2>b) ldconfig was also
performed</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008> <FONT
face=Arial color=#0000ff size=2>Can you please let me know what else might be
the problem as I am in a urgency to load GIS data in PostgreSQL (with Post
GIS).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2>Regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=200263213-30012008><FONT face=Arial
color=#0000ff size=2>Ahmad</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Andy
Dale<BR><B>Sent:</B> Wednesday, January 30, 2008 6:53 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Problems while loading
lwpostgis.sql... Pleaseprovide your inputs / help<BR></FONT><BR></DIV>
<DIV></DIV>Hi,<BR><BR>Have you added /usr/local/lib to /etc/ld.so.conf and then
performed a ldconfig ?<BR><BR>Cheers,<BR><BR>Andy<BR><BR>
<DIV><SPAN class=gmail_quote>On 30/01/2008, <B class=gmail_sendername><A
href="mailto:ahmadbasha.shaik@wipro.com">ahmadbasha.shaik@wipro.com</A></B>
<<A
href="mailto:ahmadbasha.shaik@wipro.com">ahmadbasha.shaik@wipro.com</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV>
<DIV><FONT face=Arial size=2>Hi </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I am facing problems while loading lwpostgis.sql
in PostGIS. Below is a detailed explanation.<BR>psql -d test -f
/usr/share/lwpostgis.sql</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial
size=2>/******************************************************************************/<BR>ERROR:
could not access file "$libdir/liblwgeom.so.1.2": No such file or
directory<BR>ERROR: current transaction is aborted, commands ignored
until end of transaction
block<BR>/******************************************************************************/</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV><FONT face=Arial
size=2></FONT>
<DIV><FONT face=Arial size=2>Hence , I tried creating a simple test.sql which
has the create replace functions for histogram. I have detailed the
environmnent that we are </FONT></DIV>
<DIV><FONT face=Arial size=2>using, the statement of lwpostgis.sql we executed
and the error encountered </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Environment:<BR>============</FONT></DIV>
<DIV><FONT face=Arial size=2>Operationg System : Red Hat Linux
3.4.5-2</FONT></DIV>
<DIV><FONT face=Arial size=2>Database : PostgreSQL 8.2.6 </FONT></DIV>
<DIV><FONT face=Arial size=2>Extensions : geos-3.0.0, proj-4.6.0,
postgis-1.2.1</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>test.sql (three sql commands that I have taken
from lwpostgis.sql to check)<BR>========</FONT></DIV>
<DIV><FONT face=Arial size=2><BR>BEGIN;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>CREATE OR REPLACE FUNCTION
histogram2d_in(cstring)<BR> RETURNS
histogram2d<BR> AS
'$libdir/liblwgeom.so.1.2',
'lwhistogram2d_in'<BR> LANGUAGE 'C'
IMMUTABLE STRICT; -- WITH (isstrict);</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>CREATE OR REPLACE FUNCTION
histogram2d_out(histogram2d)<BR>
RETURNS cstring<BR> AS
'$libdir/liblwgeom.so.1.2',
'lwhistogram2d_out'<BR> LANGUAGE 'C'
IMMUTABLE STRICT; -- WITH (isstrict);</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>CREATE TYPE histogram2d
(<BR> alignment =
double,<BR> internallength =
variable,<BR> input =
histogram2d_in,<BR> output =
histogram2d_out,<BR> storage =
main<BR>);</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>COMMIT;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ERROR
Encountered<BR>================</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>BEGIN<BR>psql:test.sql:6: NOTICE: type
"histogram2d" is not yet defined<BR>DETAIL: Creating a shell type
definition.<BR>psql:test.sql:6: ERROR: could not access file
"$libdir/liblwgeom.so.1.2": No such file or directory<BR>psql:test.sql:11:
ERROR: current transaction is aborted, commands ignored until end of
transaction block<BR>psql:test.sql:19: ERROR: current transaction is
aborted, commands ignored until end of transaction
block<BR>ROLLBACK</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Varions Options we
tried:<BR>==================<BR>a) Changed the permissions $libdir i.e.
/usr/lib/pgsl to 777<BR>b) Hardcoded the path /usr/lib/pgsql in this
test.sql<BR>c) We also tried hardcoding the path /usr/lib/pgsql instead of
$libdir in lwpostgis.sql when we tried loading functions and types in
lwpostgis.sql</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><BR>Can somebody please guide us or give
directions what can be done. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Regards<BR>Ahmad</FONT></DIV></DIV>
<P><STRONG><SPAN
style="FONT-SIZE: 24pt; COLOR: green; FONT-FAMILY: Webdings">P</SPAN></STRONG><STRONG><SPAN
style="FONT-SIZE: 10pt; COLOR: green"> Please do not print this email unless
it is absolutely necessary. Spread environmental
awareness.</SPAN></STRONG><SPAN></SPAN></P>
<P>The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments. </P>
<P>WARNING: Computer viruses can be transmitted via email. The recipient
should check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted by
this email. </P>
<P><A onclick="return top.js.OpenExtLink(window,event,this)"
href="http://www.wipro.com" target=_blank>www.wipro.com</A>
</P><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><p class=MsoNormal><strong><span style='font-size:24.0pt;font-family:Webdings;
color:green'>P</span></strong><strong><span style='font-size:10.0pt;font-family:
"Palatino Linotype","serif";color:green'> Please do not print this email unless it is absolutely necessary. Spread environmental awareness.</span></strong><span style='font-family:"Arial","sans-serif"'><o:p></o:p></span></p>
<p> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. </p>
<p>WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. </p>
<p>
www.wipro.com
</p>
</BODY></HTML>