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: [email protected] [mailto:postgis-users- >> [email protected]] On Behalf Of Mathieu Basille >> Sent: Thursday, September 15, 2011 1:08 PM >> To: [email protected] >> 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 >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
