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

PostGIS trac at osgeo.org
Wed Aug 29 04:43:02 PDT 2012 

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

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


Comment:

 I'm going to close this out.  Maybe it was a bug with pg 9.2beta4
 pg_restore loading into 9.1 database.  I just reloaded my data with 9.2RC1
 on my new 9.2 instance and now this looks right:


 {{{
 CREATE TABLE assessing.parceltime_2005
 (
 -- Inherited from table assessing.parceltime:  pid character(10) NOT NULL,
 -- Inherited from table assessing.parceltime:  cm_id character(10),
 -- Inherited from table assessing.parceltime:  st_num character
 varying(10),
 -- Inherited from table assessing.parceltime:  st_name character
 varying(75),
 -- Inherited from table assessing.parceltime:  name_suf character
 varying(20),
 -- Inherited from table assessing.parceltime:  unit_num character
 varying(10),
 -- Inherited from table assessing.parceltime:  zipcode character
 varying(10),
 -- Inherited from table assessing.parceltime:  ptype integer,
 -- Inherited from table assessing.parceltime:  lu character varying(5),
 -- Inherited from table assessing.parceltime:  exmpt_code character
 varying(20),
 -- Inherited from table assessing.parceltime:  ownocc character
 varying(1),
 -- Inherited from table assessing.parceltime:  owner character
 varying(150),
 -- Inherited from table assessing.parceltime:  address character
 varying(150),
 -- Inherited from table assessing.parceltime:  city_state character
 varying(75),
 -- Inherited from table assessing.parceltime:  mail_zip character
 varying(10),
 -- Inherited from table assessing.parceltime:  landval bigint,
 -- Inherited from table assessing.parceltime:  bldgval bigint,
 -- Inherited from table assessing.parceltime:  totalval bigint,
 -- Inherited from table assessing.parceltime:  gross_tax numeric(31,15),
 -- Inherited from table assessing.parceltime:  legal_area bigint,
 -- Inherited from table assessing.parceltime:  year_built integer,
 -- Inherited from table assessing.parceltime:  year_remod integer,
 -- Inherited from table assessing.parceltime:  gross_area bigint,
 -- Inherited from table assessing.parceltime:  area bigint,
 -- Inherited from table assessing.parceltime:  num_floors numeric(31,15),
 -- Inherited from table assessing.parceltime:  class character
 varying(15),
 -- Inherited from table assessing.parceltime:  r_bldg_stl character
 varying(50),
 -- Inherited from table assessing.parceltime:  r_roof_typ character
 varying(50),
 -- Inherited from table assessing.parceltime:  r_ext_fin character
 varying(100),
 -- Inherited from table assessing.parceltime:  total__rms integer,
 -- Inherited from table assessing.parceltime:  r_bdrms integer,
 -- Inherited from table assessing.parceltime:  r_full_bth integer,
 -- Inherited from table assessing.parceltime:  r_half_bth integer,
 -- Inherited from table assessing.parceltime:  r_kitch integer,
 -- Inherited from table assessing.parceltime:  r_heat_typ character
 varying(1),
 -- Inherited from table assessing.parceltime:  r_ac character varying(1),
 -- Inherited from table assessing.parceltime:  r_fplace integer,
 -- Inherited from table assessing.parceltime:  s_num_bldg integer,
 -- Inherited from table assessing.parceltime:  s_bldg_sty character
 varying(5),
 -- Inherited from table assessing.parceltime:  s_unit_res integer,
 -- Inherited from table assessing.parceltime:  s_unit_com integer,
 -- Inherited from table assessing.parceltime:  s_unit_rc integer,
 -- Inherited from table assessing.parceltime:  s_ext_fin character
 varying(2),
 -- Inherited from table assessing.parceltime:  u_base_flr integer,
 -- Inherited from table assessing.parceltime:  u_num_prk integer,
 -- Inherited from table assessing.parceltime:  u_corner character
 varying(1),
 -- Inherited from table assessing.parceltime:  u_orient character
 varying(2),
 -- Inherited from table assessing.parceltime:  u_num_rms integer,
 -- Inherited from table assessing.parceltime:  u_num_beds integer,
 -- Inherited from table assessing.parceltime:  u_bths integer,
 -- Inherited from table assessing.parceltime:  u_half_bth integer,
 -- Inherited from table assessing.parceltime:  u_kitch character
 varying(2),
 -- Inherited from table assessing.parceltime:  u_heat character
 varying(2),
 -- Inherited from table assessing.parceltime:  u_ac character varying(1),
 -- Inherited from table assessing.parceltime:  u_fplaces integer,
 -- Inherited from table assessing.parceltime:  xcoord numeric(31,15),
 -- Inherited from table assessing.parceltime:  oldycoord numeric(31,15),
 -- Inherited from table assessing.parceltime:  the_geom geometry,
 -- Inherited from table assessing.parceltime:  the_point geometry,
 -- Inherited from table assessing.parceltime:  entrytime timestamp without
 time zone NOT NULL DEFAULT now(),
 -- Inherited from table assessing.parceltime:  pid_year smallint NOT NULL,
 -- Inherited from table assessing.parceltime:  neighborhood character
 varying(50),
 -- Inherited from table assessing.parceltime:  wpd character varying(20),
 -- Inherited from table assessing.parceltime:  old_geom geometry,
 -- Inherited from table assessing.parceltime:  councildist character
 varying(15),
 -- Inherited from table assessing.parceltime:  ycoord numeric(31,15),
 -- Inherited from table assessing.parceltime:  manualupdate boolean
 DEFAULT false,
 -- Inherited from table :  st_num_longer character varying(30),
 -- Inherited from table :  nstnum_start integer,
 -- Inherited from table :  nstnum_end integer,
 -- Inherited from table :  censustract character(7),
 -- Inherited from table :  zone character varying(70),
 -- Inherited from table :  zipcode9 character varying(10),
 -- Inherited from table :  geom_merc geometry,
   CONSTRAINT enforce_dims_old_geom CHECK (st_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 (st_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
 );
 }}}

 and I verified I didn't fix it in the old database yet.
 So I have no idea what the issue was before.

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