[postgis-devel] [PostGIS] #2122: [raster] Real extent feature lost after metadata as views

[Mateusz Loskot]

On 30 November 2012 16:16, Sandro Santilli <strk at keybit.net> wrote:
> On Fri, Nov 30, 2012 at 08:07:57AM -0800, Bborie Park wrote:
>> >
>> > Couldn't (or doesn't) a constraint contain the original extent ?
>> > The same information that you would have put into the raster_column field.
>> >
>>
>> It could be done as a constraint... a constraint that does not enforce
>> anything.  The problem with constraints that don't enforce anything is
>> that they're static and may go out of date...
>
> It could also constraint: all raster tiles  must be covered bu that extent.
>
>> There are a whole set of constraints present...
>>
>> srid
>> extent
>
> ^^^ so there's one already ?

Yes, it is not sufficient in the non-evenly tiled raster.
See the 256x256 vs 300x300 example I posted in the ticket.

Best regards
--
Mateusz Loskot, http://mateusz.loskot.net