[postgis-devel] [PostGIS] #180: History table example implementation

PostGIS trac at osgeo.org
Wed Jul 8 19:04:24 PDT 2009


#180: History table example implementation
--------------------------+-------------------------------------------------
  Reporter:  pramsey      |       Owner:  pimpaa       
      Type:  enhancement  |      Status:  assigned     
  Priority:  medium       |   Milestone:  postgis 1.5.0
 Component:  postgis      |     Version:               
Resolution:               |    Keywords:               
--------------------------+-------------------------------------------------
Comment (by pimpaa):

 Hello everyone again.

 I´ve tweaked the functions a little bit, and in this present release you
 don´t need as many parameters as you would in v02.

 Now build_history_table() and then
 create_history_table(schema,table,geometry_field).

 I´m requiring the geometry field as a parameter because it is possible to
 have multiple geometries in the same table. I realize now, that even with
 multiple geometries the historic will work just fine, but it will not
 update the geometry_columns for n geometries.

 Another constraint is that the function get's the primary key field name
 from the "parent table", but in the present only works with single field
 primary keys. If your primary key has more than one field the tracking
 used in current function will not work also.

 These functions are already creating some indexes on the historic table
 (check last function).

 The names of functions are not definitive.

 I´m open to suggestions. Now i will try to copy the indexes of the parent
 table in a easy way.
 Please let me know what you guys think of this.

 George

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/180#comment:16>
PostGIS <http://trac.osgeo.org/postgis/>
PostGIS


More information about the postgis-devel mailing list