[postgis-users] New Upcoming Feature: History Tables

[George Silva]

Hello all!

I´ve been trying to help the postgis community by building this type of
feature. This was asked in trac, as shown here:
http://trac.osgeo.org/postgis/ticket/180

Well, i came up with a solution (check v03.sql) that will create some
functions to help create and manage these historic tables.

When you build a historic table the monitoring begins. All table fields are
monitored including geometry, making it possible to insert the historic
records to any GIS software. Some indexes are created now too, but i´m not
sure how useful they will be.

This is a work in progress, so i appreciate if any of you can take a look
and evaluate the current code/features.

First, run the .sql file to your database
Second, run the following command: select build_history_table(); This will
create a simple table that acts like a geometry_columns table, keeping
records about all historic tables created; (im aware of the names of the
functions, this will change)

After that you ran the commando above, you are ready to use the main
function create_history_table(schema_name,table_name,geometry_field_name).
This will set up the historic table for the declared table in the function
and all the rules necessary to maintain these records. I tested this, but
not in a extensive manner.

Anyway, i would like your input, comments, critics and suggestions of other
features. For now i'm creating functions to drop historic tables and
tweaking the indexes creation on the database.

Please, tell me what you think and especially if you find any bugs.

Thanks

George

-- 
George R. C. Silva
Sigma Consultoria

Desenvolvimento em GIS
www.consultoriasigma.com.br
www.sigmaconsultoria.blogspot.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090709/f5be9a1c/attachment.html>