Opened 6 years ago

Closed 5 years ago

#4133 closed defect (invalid)

raster2pgsql WARNING: Unable to add constraint: 'regular_blocking'. Skipping

Reported by: osgeoap Owned by: Bborie Park
Priority: medium Milestone: PostGIS 2.4.7
Component: raster Version: 2.4.x
Keywords: regular_blocking Cc:

Description

raster2pgsql: PostGIS 2.4.4, PostGres 10.4, Windows10/64, the following error occurs upon loading an image, QGIS does not allow me to load the view using DB MANAGER.

2018-07-24 17:53:00.379 EDT [1322068] WARNING: Unable to add constraint: 'regular_blocking'. Skipping 2018-07-24 17:53:00.379 EDT [1322068] CONTEXT: PL/pgSQL function addrasterconstraints(name,name,name,text[]) line 113 at RAISE PL/pgSQL function addrasterconstraints(name,name,name,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean,boolean) line 53 at RETURN

Change History (4)

comment:1 by pramsey, 6 years ago

Milestone: PostGIS 2.4.5PostGIS 2.4.6

comment:2 by pramsey, 5 years ago

Milestone: PostGIS 2.4.6PostGIS 2.4.7

comment:3 by robe, 5 years ago

Component: postgisraster
Owner: changed from pramsey to Bborie Park

comment:4 by robe, 5 years ago

Resolution: invalid
Status: newclosed

I'm guessing the image you tiled and are you are trying to load is not regularly blocked. Please use our mailing list and provide more details about your image https://lists.osgeo.org/mailman/listinfo/postgis-users . There might be a work around for it.

Thought I didn't think dbmanager cared whether your tiles are regularly blocked or not so you might have a different issue here as well.

Note: See TracTickets for help on using tickets.