On Thu, Oct 03, 2013 at 07:34:25AM +0200, Anne Quesnel wrote: > Dear all, > About hard upgrade from old to new environment. > > I followed process from this link: > http://trac.osgeo.org/postgis/wiki/UsersWikiWinUpgrade > > The new environment os is windows 7 "64 bits", pgSQL 9.3 & postgis 2.1.0-2 > > > The old environment(oracle vm virtual box: 4.1.12r77218, ubuntu 12.04 LTS, > pg SQL 9.1, postgis 1.5.3. > > > > I have made two hard upgrades on windows with a file.backup "tar" and a > file.dump "custom format". > > My both files "error.txt" are empty. > > Knowing that "the geometry_column table" is no longer a table in the new > postgis version, I' ve got 7 on 8 tables, but it's normal. > > But If we make comparaison between the remaining tables : I' ve got > missing values in the "the_geom geometry" attribute of three tables. > > my database is from a "postgis workshop" and it's called "nyc" > the tables with missing values are: > > public.nyc_census_blocks > public.nyc_neighborhoods > public.queens > > Could you help me for this problem?
Are you missing values or full records ? SELECT count(*) from public.nyc_census_blocks; SELECT count(*) from public.nyc_census_blocks WHERE the_geom IS NULL; --strk; _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
