Great ideas in the Geoserver docs on how to do versioning, and other changes over time in a geospatial database, the right way — by extending WFS .

http://geoserver.org/display/GEOS/Versioning+WFS+-+Extensions