首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >postgres postgis 2.5数据库中不存在pgis_abs

postgres postgis 2.5数据库中不存在pgis_abs
EN

Stack Overflow用户
提问于 2019-12-12 01:08:14
回答 1查看 798关注 0票数 1

我在试图恢复postgres数据库。

此数据库包括postgis数据。但是,在还原sql转储时,我遇到了以下错误:

代码语言:javascript
运行
复制
psql:postgis_db_dump.sql:2174: ERROR:  type "public.pgis_abs" does not exist

正在运行的系统已经安装了postgresql-10-postgis-2.4,而我试图将其还原到的新系统也安装了postgresql-11-postgis-2.5

关于旧系统dT \dT给出:

代码语言:javascript
运行
复制
 Schema |       Name        |                                                                                 Description                                                                                 
--------+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 public | addbandarg        | postgis raster type: A composite type used as input into the ST_AddBand function defining the attributes and initial value of the new band.
 public | agg_count         | 
 public | agg_samealignment | 
 public | box2d             | postgis type: A box composed of x min, ymin, xmax, ymax. Often used to return the 2d enclosing box of a geometry.
 public | box2df            | 
 public | box3d             | postgis type: A box composed of x min, ymin, zmin, xmax, ymax, zmax. Often used to return the 3d extent of a geometry or collection of geometries.
 public | box3d_extent      | 
 public | chip              | 
 public | geography         | postgis type: Ellipsoidal spatial data type.
 public | geometry          | postgis type: Planar spatial data type.
 public | geometry_dump     | postgis type: A spatial datatype with two fields - geom (holding a geometry object) and path[] (a 1-d array holding the position of the geometry within the dumped object.)
 public | geomval           | postgis raster type: A spatial datatype with two fields - geom (holding a geometry object) and val (holding a double precision pixel value from a raster band).
 public | gidx              | 
 public | pgis_abs          | 
 public | rastbandarg       | postgis raster type: A composite type for use when needing to express a raster and a band index of that raster.
 public | raster            | postgis raster type: raster spatial data type.
 public | reclassarg        | postgis raster type: A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
 public | spheroid          | 
 public | summarystats      | postgis raster type: A composite type returned by the ST_SummaryStats and ST_SummaryStatsAgg functions.
 public | unionarg          | postgis raster type: A composite type used as input into the ST_Union function defining the bands to be processed and behavior of the UNION operation.
 public | valid_detail      | 
(21 rows)

但在新的系统里:

代码语言:javascript
运行
复制
 Schema |         Name         |                                                                                 Description                                                                                 
--------+----------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 public | addbandarg           | postgis raster type: A composite type used as input into the ST_AddBand function defining the attributes and initial value of the new band.
 public | agg_count            | 
 public | agg_samealignment    | 
 public | box2d                | postgis type: A box composed of x min, ymin, xmax, ymax. Often used to return the 2d enclosing box of a geometry.
 public | box2df               | 
 public | box3d                | postgis type: A box composed of x min, ymin, zmin, xmax, ymax, zmax. Often used to return the 3d extent of a geometry or collection of geometries.
 public | geography            | postgis type: Ellipsoidal spatial data type.
 public | geometry             | postgis type: Planar spatial data type.
 public | geometry_dump        | postgis type: A spatial datatype with two fields - geom (holding a geometry object) and path[] (a 1-d array holding the position of the geometry within the dumped object.)
 public | geomval              | postgis raster type: A spatial datatype with two fields - geom (holding a geometry object) and val (holding a double precision pixel value from a raster band).
 public | gidx                 | 
 public | rastbandarg          | postgis raster type: A composite type for use when needing to express a raster and a band index of that raster.
 public | raster               | postgis raster type: raster spatial data type.
 public | reclassarg           | postgis raster type: A composite type used as input into the ST_Reclass function defining the behavior of reclassification.
 public | spheroid             | 
 public | summarystats         | postgis raster type: A composite type returned by the ST_SummaryStats and ST_SummaryStatsAgg functions.
 public | tablefunc_crosstab_2 | 
 public | tablefunc_crosstab_3 | 
 public | tablefunc_crosstab_4 | 
 public | textual_identity     | 
 public | unionarg             | postgis raster type: A composite type used as input into the ST_Union function defining the bands to be processed and behavior of the UNION operation.
 public | valid_detail         | 
(22 rows)

数据类型似乎不再存在。有人知道处理这件事的最佳方法吗?

EN

回答 1

Stack Overflow用户

发布于 2019-12-12 01:41:22

显然,pgis_abs列是一个虚拟列,根据这份承诺

4035,从聚合/收集例程中删除虚拟pgis_abs类型

听起来应该可以在执行升级之前删除pgis_abs列。

另见这个职位

票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/59296323

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档