[postgis-users] problem with topology

[Sufficool, Stanley]

This is exactly how I version data. I use a trigger function in
PostgreSQL to detect column changes and insert the OLD.<geometry column>
with the OLD.<pkey_column> to another table (try <table name>_history.
The target table has columns with default values for recording the
date/time and user that performed the transaction. 
 
 
create function tr_geom_trans()  returns trigger as $$
BEGIN
 insert into mytable_history (table_id, old_geom, mod_date, mod_user)
SELECT OLD.oid, OLD.the_geom, now(), current_user;
 return NEW;
END;
 
$$
language "plpgsql" volatile

 

	-----Original Message-----
	From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Brian Sanjeewa Rupasinghe
	Sent: Monday, January 05, 2009 5:44 AM
	To: postgis-users at postgis.refractions.net
	Subject: [postgis-users] problem with topology
	
	
	I have a land parcel (polygon) stored in postGIS with a ceratin
feature ID, say FID = 100. I want to split this polygon into two
building topology for new two polygons, and sending the original polygon
(i.e FID = 100) into history with the use of a trigger. Is it possible?
Polygon split is done by 
	a GIS software that is connected to PostGIS.
	
	SANJEEWA
	

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090105/8fa747a5/attachment.html>