[postgis-users] (no subject)

Wed May 13 00:17:28 PDT 2009

Hi..
Thank you for your reply....

the first few lines are:

 psql -d newpsqldb -f lwpostgis.sql -U postgres | less
psql:lwpostgis.sql:44: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:lwpostgis.sql:44: ERROR:  could not load library
"/usr/local/pgsql/lib/liblwgeom.so": libgeos_c.so.1: cannot open shared
object file: No such file or directory
psql:lwpostgis.sql:50: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:56: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:62: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:70: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:88: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:94: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:100: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:106: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:113: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:131: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:137: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:143: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:149: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:159: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:170: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:176: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:183: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:189: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:196: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:202: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:209: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:215: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:222: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:228: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:235: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:241: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:247: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:253: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:259: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:265: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:272: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:278: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:285: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:291: ERROR:  current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:299: ERROR:  current transaction is aborted, commands
ignored until end of transaction block

Thank you.

Regards,
Rahul Pachaghare
Member,TEG Open Source
Tata Consultancy Services
Mailto: rahul.pachaghare at tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                  Business Solutions
                  Outsourcing
____________________________________________

             Ben Madin                                                     
             <ben at remoteinform                                             
             ation.com.au>                                              To 
             Sent by:                  PostGIS Users Discussion            
             postgis-users-bou         <postgis-users at postgis.refractions. 
             nces at postgis.refr         net>                                
             actions.net                                                cc 

                                                                   Subject 
             05/13/2009 12:25          Re: [postgis-users] (no subject)    
             PM                                                            

             Please respond to                                             
               PostGIS Users                                               
                Discussion                                                 
             <postgis-users at po                                             
             stgis.refractions                                             
                   .net>                                                   

Rahul,

For a start, look at the start of the list of errors - something has
gone wrong, and so nothing else is being processed - try sending the
first few lines of the errors.

cheers

Ben

On 13/05/2009, at 2:26 PM, rahul.pachaghare at tcs.com wrote:

>
> Hi,
> I am new to this and I am trying to install PostGIS -1.3.6.I have
> followed
> the instructions upto createlang plpgsql..But for
>
> Now load the PostGIS object and function definitions into your
> database by
> loading the lwpostgis.sql definitions file.
>
>
> # psql -d [yourdatabase] -f lwpostgis.
>
>
> I am getting a huge errors.The errors are as:
> psql:lwpostgis.sql:3295: ERROR:  current transaction is aborted,
> commands
> ignored until end of transaction block
> psql:lwpostgis.sql:6533: ERROR:  current transaction is aborted,
> commands
> ignored until end of transaction block
> ROLLBACK
>
> Above is not the complete list of errors.....Anyone got any idea?
>
> Thank You in advance.
>
> Regards,
> Rahul Pachaghare

--

Ben Madin
REMOTE INFORMATION

t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome   WA   6725

ben at remoteinformation.com.au

       Out here, it pays to know...

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

ForwardSourceID:NT00003A76

=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you