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

[PostGIS]

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

 George,
 Sorry about that.  I guess with preparing for release of 1.4 and
 vacations, everyone has been tied up.

 I did take a quick look at the code, and will have to test drive it a bit
 before I can make an informed opinion.  My first thought -- as much as I
 love PostgreSQL rules, I have some misgivings about using it for history
 management.

 One of them which is somewhat minor -- is that count stats don't return
 right which is kind of confusing when inserting data if you rely on that.
 Then again triggers have there own issues like being called for each row
 as opposed to an SQL rewrite rule.

 I guess my misgivings is more not so much misgiving as I haven't weighed
 the pros and cons of using a rewrite rule vs. a trigger in this context.
 A trigger would give you more control in running more complex logic etc,
 but you may not need that level of control anyway.

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