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

PostGIS trac at osgeo.org
Tue Oct 7 15:52:38 PDT 2008


#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 pramsey):

 The point is not to track just changes in geometry, but history globally
 on teh table. the _history table should include every attribute in the
 original table, plus the history tracking attributes. You'll probably need
 to build it either using table inheritance (not sure if that would work)
 or by querying the system tables to get the information about what columns
 exist in the table.

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


More information about the postgis-devel mailing list