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

[dustymugs]

Something else wrong.  I just tested upgrading from 2.0.1 to 2.0.3 using
rtpostgis_upgrade_20_minor.sql and there were no problems.

Where'd you get your postgis installer?

-bborie

On 04/19/2013 10:09 AM, ryagz wrote:
> 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.
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
>