[postgis-users] (no subject)
rahul.pa...@tcs.com
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:3334: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3347: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3354: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3359: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3365: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3374: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3378: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3388: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3392: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3397: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3401: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3405: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3409: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3413: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3417: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3469: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3479: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3485: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3491: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3497: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3503: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3509: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3515: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3521: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3527: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3533: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3539: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3545: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3551: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3557: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3564: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3570: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3576: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3582: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3588: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3594: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3600: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3606: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3612: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3618: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3624: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3630: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3636: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3642: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3648: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3651: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3652: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3653: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3654: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3655: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3656: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3657: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3658: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3659: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3660: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3661: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3662: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3663: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3674: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3680: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3687: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3693: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3700: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3706: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3713: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3719: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3726: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3732: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3738: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3744: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3754: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3760: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3766: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3772: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3778: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3784: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3790: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3796: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3802: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3808: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3818: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3824: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3830: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3836: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3842: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3848: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3854: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3860: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3867: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3873: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3879: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3885: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3891: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3897: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3903: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3909: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3915: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3921: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3927: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3934: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3941: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3947: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3953: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3961: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3969: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3975: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3981: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3987: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3993: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:3999: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4005: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4011: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4017: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4024: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4030: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4036: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4042: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4048: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4055: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4060: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4066: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4073: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4079: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4085: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4092: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4098: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4104: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4111: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4117: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4123: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4129: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4136: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4142: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4149: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4155: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4161: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4168: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4174: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4181: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4187: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4193: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4199: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4205: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4211: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4217: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4223: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4229: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4235: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4241: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4247: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4253: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4263: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4269: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4275: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4281: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4287: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4293: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4302: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4309: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4315: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4322: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4328: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4335: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4342: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4352: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4359: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4365: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4372: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4379: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4385: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4392: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4399: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4409: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4415: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4421: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4427: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4433: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4439: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4445: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4456: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4462: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4468: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4474: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4480: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4486: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4492: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4498: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4504: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4510: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4516: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4522: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4528: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4534: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4540: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4546: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4552: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4579: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4585: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4591: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4597: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4603: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4609: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4615: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4621: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4627: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4633: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4639: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4645: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4651: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4657: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4663: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4669: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4675: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4681: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4687: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4693: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4699: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4705: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4711: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4717: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4723: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4729: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4735: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4741: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4747: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4753: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4759: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4765: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4771: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4777: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4782: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4787: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4792: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4797: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4807: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4817: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4827: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4838: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4848: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4858: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4868: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4878: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4884: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4890: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4900: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4910: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4920: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4930: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4936: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4942: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4948: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4954: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4965: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4976: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4986: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:4996: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5002: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5008: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5014: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5020: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5030: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5040: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5050: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5060: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5066: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5072: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5078: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5084: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5090: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5100: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5110: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5120: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5130: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5136: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5142: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5148: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5154: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5165: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5176: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5187: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5198: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5204: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5210: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5216: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5222: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5232: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5242: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5252: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5262: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5272: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5282: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5292: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5302: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5312: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5322: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5332: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5342: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5352: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5362: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5372: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5382: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5392: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5402: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5412: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5422: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5432: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5442: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5452: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5462: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5472: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5482: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5492: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5502: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5512: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5522: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5532: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5542: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5552: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5562: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5572: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5582: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5592: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5602: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5612: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5622: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5632: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5642: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5652: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5662: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5673: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5684: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5695: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5706: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5749: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5778: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5814: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5838: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5882: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5933: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5940: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5947: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5954: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:5987: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6020: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6027: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6032: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6037: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6096: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6114: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6159: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6218: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6238: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6295: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6318: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6332: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6346: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6360: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6366: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6372: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6410: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6459: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6482: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6488: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6512: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6523: ERROR: current transaction is aborted, commands
ignored until end of transaction block
psql:lwpostgis.sql:6528: 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
Member,TEG Open Source
Tata Consultancy Services
Mailto: rahul.pa...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
=====-----=====-----=====
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
postgi...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
strk
>
> 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!
Anton Patrushev
It looks like you forgot to create Pl/pgSQL language in your database.
Anton.
Ben Madin
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.pa...@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
Out here, it pays to know...
rahul.pa...@tcs.com
I have created plgsql with the command
createlang plpgsql [yourdatabase]
Thank you.
Regards,
Rahul Pachaghare
Member,TEG Open Source
Tata Consultancy Services
Mailto: rahul.pa...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
Anton Patrushev
<an...@orkney.co.
jp> To
Sent by: PostGIS Users Discussion
postgis-users-bou <postgi...@postgis.refractions.
nc...@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@po
stgis.refractions
.net>
Hi,
Anton.
ForwardSourceID:NT00003A6E
Pradeep B V
See if this can help
http://www.mail-archive.com/postgi...@postgis.refractions.net/msg00644.html
- p
Pradeep B V
+91 94498 23772
rahul.pa...@tcs.com
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.pa...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
Ben Madin
<ben@remoteinform
ation.com.au> To
Sent by: PostGIS Users Discussion
postgis-users-bou <postgi...@postgis.refractions.
nc...@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@po
stgis.refractions
.net>
Rahul,
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
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
_______________________________________________
rahul.pa...@tcs.com
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.pa...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
strk
<st...@keybit.net>
Sent by: To
postgis-users-bou PostGIS Users Discussion
nc...@postgis.refr <postgi...@postgis.refractions.
actions.net net>
cc
05/13/2009 12:21 Subject
PM Re: [postgis-users] (no subject)
Please respond to
PostGIS Users
Discussion
<postgis-users@po
stgis.refractions
.net>
--strk;
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
_______________________________________________
strk
>
> 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
Did you run 'ldconfig' as root after installing GEOS ?
rahul.pa...@tcs.com
[Rahul@localhost postgis-1.3.6]$ psql -d psqldb -f lwpostgis.sql | 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
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
Regards,
Rahul Pachaghare
Member,TEG Open Source
Tata Consultancy Services
Mailto: rahul.pa...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
strk
<st...@keybit.net>
Sent by: To
postgis-users-bou PostGIS Users Discussion
nc...@postgis.refr <postgi...@postgis.refractions.
actions.net net>
cc
05/13/2009 01:37 Subject
PM [postgis-users] Re: errors loading
postgis.sql
Please respond to
PostGIS Users
Discussion
<postgis-users@po
stgis.refractions
.net>
--strk;
ForwardSourceID:NT00003AB2
=====-----=====-----=====
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
_______________________________________________