[postgis-users] why does the raster_columns , geometry_columns and raster_overviews are made as view istead of tables

[Bborie Park]

On 02/14/2012 10:01 AM, Zelio Fernandes wrote:
> Hi
>
> after going to one of the post i read that raster_columns , geometry_columns
> and raster_overview were initially  tables. i am very curious to know why it
> has been changed to Views ......*what is the reason behind it??*
>

When raster_columns and geometry_columns were tables, they required 
manual updating of records, typically resulting in out-of-date 
information over time.  With views, the records are always up-to-date 
because of the use of geometry typemod or table/column constraints.

-bborie

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu