[postgis-users] How to keep raster_columns clean?

[Mathieu Basille]

Dear Pierre,

Actually, I just discovered recently the content of this table, and
found it really interesting! I thus intended to use it as a convenient
way to list and summarize the rasters we have in the DB (with an
overview of CRS, pixel size, etc.).

Given your answer, it doesn't seem to be such a good idea to rely on it yet!

Best,
Mathieu.


Le 2011-09-15 16:48, Pierre Racine a écrit :
> What do you use the raster_column table for?
> 
> We might provide later function to 'clean' or 'synch' the raster_column table with the database content. But we are not there yet.
> 
> Pierre
> 
>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
>> bounces at postgis.refractions.net] On Behalf Of Mathieu Basille
>> Sent: Thursday, September 15, 2011 1:08 PM
>> To: postgis-users at postgis.refractions.net
>> Subject: [postgis-users] How to keep raster_columns clean?
>>
>> Dear PostGIS gurus,
>>
>> I just realized that the table 'raster_columns' was not updated with
>> modifications on raster tables (e.g. removing a table, dropping a table, or
>> changing the schema of a table).
>>
>> Is there any way to keep this table clean? I tried a VACUUM (as recommanded
>> by pgAdmin itself), but it didn't seem to do the trick.
>>
>> Any hint? Maybe I did something wrong from the beginning?
>> Mathieu Basille.
>>
>>
>> --
>>
>> ~$ whoami
>> Mathieu Basille, Post-Doc
>>
>> ~$ locate
>> Laboratoire d'Écologie Comportementale et de Conservation de la Faune
>> + Centre d'Étude de la Forêt
>> Département de Biologie
>> Université Laval, Québec
>>
>> ~$ info
>> http://ase-research.org/basille
>>
>> ~$ fortune
>> ``If you can't win by reason, go for volume.''
>> Calvin, by Bill Watterson.
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

~$ whoami
Mathieu Basille, Post-Doc

~$ locate
Laboratoire d'Écologie Comportementale et de Conservation de la Faune
+ Centre d'Étude de la Forêt
Département de Biologie
Université Laval, Québec

~$ info
http://ase-research.org/basille

~$ fortune
``If you can't win by reason, go for volume.''
Calvin, by Bill Watterson.