[postgis-devel] Raster: Raster2pgsql -V option why do we need it?

[Mateusz Loskot]

On 14/02/11 16:30, Pierre Racine wrote:
>> I noticed this switch:
>>
>> -V, --create-raster-overviews
>>
>> I'm not really clear why we need this since when you install
>> raster support -- it creates an empty raster_overviews table in the
>> public schema. Is the intention to have a separate overviews table
>> for each schema (which is not documented as such and also doesn't
>> make much sense to me).
>
> Mateusz have the last answer but I don't think so. Only one table
> and in the public schema.

I added the -V option to allow low-level control during raster loading.

http://trac.osgeo.org/postgis/changeset/4090

At the time it was added, as far as I remember, it was not clear if the
RASTER_OVERVIEWS table will become first class citizen of the RASTER
metadata. Looking at the specification, RASTER_OVERVIEWS seems to be
still marked as a sort of proposal:

http://trac.osgeo.org/postgis/wiki/WKTRaster/SpecificationWorking01

* there are two alternatives presented
* pros and cons discussed
* "no provision is provided"

Thus to overcome this uncertainty, I provided some support in the loader
script. It may be redundant now indeed.

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org