[postgis-devel] AddRasterConstraints failing to create extents in raster_column view

ryagz raghavendra at vizexperts.com
Fri Apr 19 10:09:47 PDT 2013 

I ran the .sql file, it ran a sequence of sql queries and then gave some
errors and roll back like bellow:

psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3764: ERROR:  function "st_union" already exists with
same a
rgument types
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3771: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3780: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3786: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3868: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3874: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3880: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3886: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3892: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3898: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3922: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3952: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:3968: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4006: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4012: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4028: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4071: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4084: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4100: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4142: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4155: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4171: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4218: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4224: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4240: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4274: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4280: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4301: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4327: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4333: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4349: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4385: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4391: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4407: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4412: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4461: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4467: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4483: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4488: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4541: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4547: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4563: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4568: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4621: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4627: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4761: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4771: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4846: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:4867: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5001: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5011: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5086: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5107: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5145: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5155: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5177: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5210: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5216: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5248: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5329: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5339: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5397: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
psql:C:/Program Files
(x86)/PostgreSQL/9.1/share/contrib/postgis-2.0/rtpostgis_u
pgrade_20_minor.sql:5406: ERROR:  current transaction is aborted, commands
ignor
ed until end of transaction block
ROLLBACK

-Ryagz



--
View this message in context: http://postgis.17.x6.nabble.com/AddRasterConstraints-failing-to-create-extents-in-raster-column-view-tp5003029p5003059.html
Sent from the PostGIS - Dev mailing list archive at Nabble.com.

More information about the postgis-devel mailing list