« Return to Thread: Re: [PostGIS] #180: History table example implementation

Re: [PostGIS] #180: History table example implementation

by PostGIS-4 :: Rate this Message:

Reply to Author | View in Thread

#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
_______________________________________________
postgis-devel mailing list
postgis-devel@...
http://postgis.refractions.net/mailman/listinfo/postgis-devel

 « Return to Thread: Re: [PostGIS] #180: History table example implementation