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: [email protected]
Website: http://www.tcs.com
____________________________________________
Experience certainty.   IT Services
                  Business Solutions
                  Outsourcing
____________________________________________


                                                                           
             strk                                                          
             <[email protected]>                                             
             Sent by:                                                   To 
             postgis-users-bou         PostGIS Users Discussion            
             [email protected]         <[email protected]. 
             actions.net               net>                                
                                                                        cc 
                                                                           
             05/13/2009 12:21                                      Subject 
             PM                        Re: [postgis-users] (no subject)    
                                                                           
                                                                           
             Please respond to                                             
               PostGIS Users                                               
                Discussion                                                 
             <postgis-us...@po                                             
             stgis.refractions                                             
                   .net>                                                   
                                                                           
                                                                           




On Wed, May 13, 2009 at 11:56:45AM +0530, [email protected] 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

You should be looking for the first error you get.
Guys, we should really document in the README the flag to tell
psql to abort on first error. I keep forgetting it.

--strk;

 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple!
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users


ForwardSourceID:NT00003A6A

=====-----=====-----=====
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



_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to