[postgis-devel] [PostGIS] #343: History Table Enhancements

[PostGIS]

#343: History Table Enhancements
----------------------+-----------------------------------------------------
  Reporter:  pimpaa   |       Owner:  pimpaa        
      Type:  defect   |      Status:  new           
  Priority:  medium   |   Milestone:  PostGIS 2.0.0 
 Component:  postgis  |     Version:  trunk         
Resolution:           |    Keywords:  History Tables
----------------------+-----------------------------------------------------
Changes (by pimpaa):

  * type:  patch => defect

Comment:

 If the original table any columns with names equal any of the specified on
 history template, the function will break.

 NOTICE:  CREATE TABLE will create implicit sequence
 "foo2_history_history_id_seq" for serial column "foo2_history.history_id"
 CONTEXT:  SQL statement "CREATE TABLE public.foo2_history(history_id
 serial not null,date_added timestamp not null default now(),date_deleted
 timestamp default null,last_operation varchar(30) not null,active_user
 varchar(90) not null default CURRENT_USER,current_version text not
 null,like public.foo2,CONSTRAINT foo2_history_pk primary
 key(history_id));"
 PL/pgSQL function "postgis_enable_history" line 69 at EXECUTE statement
 ERROR:  column "date_added" specified more than once
 CONTEXT:  SQL statement "CREATE TABLE public.foo2_history(history_id
 serial not null,date_added timestamp not null default now(),date_deleted
 timestamp default null,last_operation varchar(30) not null,active_user
 varchar(90) not null default CURRENT_USER,current_version text not
 null,like public.foo2,CONSTRAINT foo2_history_pk primary
 key(history_id));"
 PL/pgSQL function "postgis_enable_history" line 69 at EXECUTE statement

 ********** Error **********

 ERROR: column "date_added" specified more than once
 SQL state: 42701
 Context: SQL statement "CREATE TABLE public.foo2_history(history_id serial
 not null,date_added timestamp not null default now(),date_deleted
 timestamp default null,last_operation varchar(30) not null,active_user
 varchar(90) not null default CURRENT_USER,current_version text not
 null,like public.foo2,CONSTRAINT foo2_history_pk primary
 key(history_id));"
 PL/pgSQL function "postgis_enable_history" line 69 at EXECUTE statement

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/343#comment:5>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.