Changeset 99

Timestamp:

07/04/11 17:02:46 (12 years ago)

Author:

astrid.emde

Message:

new table delete and function to delete features

File:

• trunk/data/konvert/transaction_delete.sql (modified) (2 diffs)

trunk/data/konvert/transaction_delete.sql

@@ -9 +9 @@
   featureid character(32),
   CONSTRAINT delete_pk PRIMARY KEY (ogc_fid)
-)
-WITH (
-  OIDS=TRUE
 );
-ALTER TABLE "delete" OWNER TO postgres;
 
 DROP FUNCTION deletefeature(text, text);
@@ -36 +32 @@
 $$ LANGUAGE plpgsql; 
 
-
-INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc');
-
-INSERT INTO delete (typename, featureid) VALUES ('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z');
-
-Select deleteFeature('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z');
-
-INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc');
-
-Select * from AA_Antragsgebiet
-
-Select substring('DENW44AL0000okRc20110428T135110Z' from 1 for 16)
+-- example
+--INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc');
+--INSERT INTO delete (typename, featureid) VALUES ('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z');
+--Select deleteFeature('AA_Antragsgebiet','DENW44AL0000okRc20110428T135110Z');
+--INSERT INTO AA_Antragsgebiet (gml_id) VALUES ('DENW44AL0000okRc');
+--Select * from AA_Antragsgebiet
 
 Select deleteFeature(typename,featureid) from delete;