[postgis-devel] [PostGIS] #1708: postgis_restore not converting ndims and srid constraints to st_...

PostGIS trac at osgeo.org
Fri Aug 24 09:26:10 PDT 2012 

#1708: postgis_restore not converting ndims and srid constraints to st_...
------------------------------------+---------------------------------------
  Reporter:  robe                   |       Owner:  strk         
      Type:  defect                 |      Status:  reopened     
  Priority:  medium                 |   Milestone:  PostGIS 2.0.1
 Component:  build/upgrade/install  |     Version:  trunk        
Resolution:                         |    Keywords:  history      
------------------------------------+---------------------------------------
Changes (by robe):

  * status:  closed => reopened
  * resolution:  fixed =>


Comment:

 This is still not working even using the utils from PostGIS 2.1.0.

 Though I wonder if its you are assuming something about the name of the
 the geometry column or your script is getting tripped up by inherited
 tables.

 Here is one case that didn't come in right: (The ones that are right I had
 changed in the old db so can't be sure if those ones are working right or
 not)


 {{{
 CREATE TABLE assessing.parceltime_2005
 (
 -- Inherited from table parceltime:  pid character(10) NOT NULL,
 -- Inherited from table parceltime:  cm_id character(10),
 -- Inherited from table parceltime:  st_num character varying(10),
 -- Inherited from table parceltime:  st_name character varying(75),
 -- Inherited from table parceltime:  name_suf character varying(20),
 -- Inherited from table parceltime:  unit_num character varying(10),
 -- Inherited from table parceltime:  zipcode character varying(10),
 -- Inherited from table parceltime:  ptype integer,
 -- Inherited from table parceltime:  lu character varying(5),
 -- Inherited from table parceltime:  exmpt_code character varying(20),
 -- Inherited from table parceltime:  ownocc character varying(1),
 -- Inherited from table parceltime:  owner character varying(150),
 -- Inherited from table parceltime:  address character varying(150),
 -- Inherited from table parceltime:  city_state character varying(75),
 -- Inherited from table parceltime:  mail_zip character varying(10),
 -- Inherited from table parceltime:  landval bigint,
 -- Inherited from table parceltime:  bldgval bigint,
 -- Inherited from table parceltime:  totalval bigint,
 -- Inherited from table parceltime:  gross_tax numeric(31,15),
 -- Inherited from table parceltime:  legal_area bigint,
 -- Inherited from table parceltime:  year_built integer,
 -- Inherited from table parceltime:  year_remod integer,
 -- Inherited from table parceltime:  gross_area bigint,
 -- Inherited from table parceltime:  area bigint,
 -- Inherited from table parceltime:  num_floors numeric(31,15),
 -- Inherited from table parceltime:  class character varying(15),
 -- Inherited from table parceltime:  r_bldg_stl character varying(50),
 -- Inherited from table parceltime:  r_roof_typ character varying(50),
 -- Inherited from table parceltime:  r_ext_fin character varying(100),
 -- Inherited from table parceltime:  total__rms integer,
 -- Inherited from table parceltime:  r_bdrms integer,
 -- Inherited from table parceltime:  r_full_bth integer,
 -- Inherited from table parceltime:  r_half_bth integer,
 -- Inherited from table parceltime:  r_kitch integer,
 -- Inherited from table parceltime:  r_heat_typ character varying(1),
 -- Inherited from table parceltime:  r_ac character varying(1),
 -- Inherited from table parceltime:  r_fplace integer,
 -- Inherited from table parceltime:  s_num_bldg integer,
 -- Inherited from table parceltime:  s_bldg_sty character varying(5),
 -- Inherited from table parceltime:  s_unit_res integer,
 -- Inherited from table parceltime:  s_unit_com integer,
 -- Inherited from table parceltime:  s_unit_rc integer,
 -- Inherited from table parceltime:  s_ext_fin character varying(2),
 -- Inherited from table parceltime:  u_base_flr integer,
 -- Inherited from table parceltime:  u_num_prk integer,
 -- Inherited from table parceltime:  u_corner character varying(1),
 -- Inherited from table parceltime:  u_orient character varying(2),
 -- Inherited from table parceltime:  u_num_rms integer,
 -- Inherited from table parceltime:  u_num_beds integer,
 -- Inherited from table parceltime:  u_bths integer,
 -- Inherited from table parceltime:  u_half_bth integer,
 -- Inherited from table parceltime:  u_kitch character varying(2),
 -- Inherited from table parceltime:  u_heat character varying(2),
 -- Inherited from table parceltime:  u_ac character varying(1),
 -- Inherited from table parceltime:  u_fplaces integer,
 -- Inherited from table parceltime:  xcoord numeric(31,15),
 -- Inherited from table parceltime:  oldycoord numeric(31,15),
 -- Inherited from table parceltime:  the_geom geometry,
 -- Inherited from table parceltime:  the_point geometry,
 -- Inherited from table parceltime:  entrytime timestamp without time zone
 NOT NULL DEFAULT now(),
 -- Inherited from table parceltime:  pid_year smallint NOT NULL,
 -- Inherited from table parceltime:  neighborhood character varying(50),
 -- Inherited from table parceltime:  wpd character varying(20),
 -- Inherited from table parceltime:  old_geom geometry,
 -- Inherited from table parceltime:  councildist character varying(15),
 -- Inherited from table parceltime:  ycoord numeric(31,15),
 -- Inherited from table parceltime:  manualupdate boolean DEFAULT false,
 -- Inherited from table parceltime:  st_num_longer character varying(30),
 -- Inherited from table parceltime:  nstnum_start integer,
 -- Inherited from table parceltime:  nstnum_end integer,
 -- Inherited from table parceltime:  censustract character(7),
 -- Inherited from table parceltime:  zone character varying(70),
 -- Inherited from table parceltime:  zipcode9 character varying(10),
 -- Inherited from table parceltime:  geom_merc geometry,
   CONSTRAINT pid_fy_pk PRIMARY KEY (pid, pid_year),
   CONSTRAINT enforce_dims_old_geom CHECK (ndims(old_geom) = 2),
   CONSTRAINT enforce_dims_the_point CHECK (st_ndims(the_point) = 2),
   CONSTRAINT enforce_geotype_geom_merc CHECK (geometrytype(geom_merc) =
 'MULTIPOLYGON'::text OR geom_merc IS NULL),
   CONSTRAINT enforce_geotype_old_geom CHECK (geometrytype(old_geom) =
 'MULTIPOLYGON'::text OR old_geom IS NULL),
   CONSTRAINT enforce_geotype_the_point CHECK (geometrytype(the_point) =
 'POINT'::text OR the_point IS NULL),
   CONSTRAINT enforce_srid_geom_merc CHECK (st_srid(geom_merc) = 900913),
   CONSTRAINT enforce_srid_old_geom CHECK (srid(old_geom) = 2249),
   CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 2249),
   CONSTRAINT enforce_srid_the_point CHECK (st_srid(the_point) = 2249),
   CONSTRAINT pid_year_cc CHECK (pid_year = 2005::smallint)
 )
 INHERITS (assessing.parceltime)
 WITH (
   OIDS=TRUE
 );
 }}}

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/1708#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.

More information about the postgis-devel mailing list