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

PostGIS trac at osgeo.org
Tue Oct 7 18:16:11 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 robe):

 Just my two cents and  should probably shut up on this.  I woudl create a
 differnt schema for history tables, kind of like how PostgreSQL has a
 different schema for toast tables so as not to confuse people and
 otherwise clutter the schema.

 So if the user schema a table is in is say public, call the history schema
 history_public or soem such thing.

 I guess thinking out loud for my scenario -- I have say 150 tables in one
 of my schemas -- most I would like to use this history feature.  But I
 won't, cause I don't want to wade thru 300 tables :)

 history is a nice thing when you need to look at it interrorogate it, but
 otherwise you want it to be abstracted away from your common workflow and
 not to confuse unsuspecting users.

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


More information about the postgis-devel mailing list