Liquibase用Postgis“几何图形”类型创建表格

Question

我正在编写一个liquibase脚本，以创建一个带有geometrio列的表（来自PostGreSQL DB的PostGis扩展）

  - changeSet:
      id: 5-change-set-places
      comment: Create places table
      author: LongLe
      validCheckSum: 1:any
      changes:
        - sql:
            dbms: postgresql
            endDelimiter: ;
            splitStatements: true
            sql: |
              CREATE TABLE IF NOT EXISTS "${schema}"."places" (
                "id" bigint NOT NULL,
                "geom" GEOMETRY(Geometry, 4326) NOT NULL
              );
              GRANT SELECT, INSERT, UPDATE, DELETE ON "${schema}"."places" TO "${rolename}";
              ALTER TABLE "${schema}"."places"
                DROP CONSTRAINT IF EXISTS "places_pkey",
                ADD CONSTRAINT "places_pkey" PRIMARY KEY ("id");

ERROR: type "geometry" does not exist

  - changeSet:
      id: 5-change-set-places
      comment: Create places table
      author: LongLe
      validCheckSum: 1:any
      changes:
        - createTable:
            columns:
              - column:
                  constraints:
                    nullable: false
                    primaryKey: true
                    primaryKeyName: places_pkey
                  name: id
                  type: bigint
              - column:
                  constraints:
                    nullable: false
                  name: geom
                  type: GEOMETRY(Geometry,4326)
            tableName: test

31-03-2021 21:07:31.587[main]警告C.M.MS.Block...applyLiquiBase-应用liquibase尝试5：更改集类路径：db/changelog/db.changelog-master.yaml：：5-change-set-places：：longle：reason：liquibase.exception.databaseException：错误：类型“几何”不存在位置：67[失败的SQL：CREATE TABLE testschema.places（id BIGINT not NULL,geom geometry（geometry,4326）not NULL,CONSTRAINT

但是当我从日志中取出SQL运行时：

CREATE TABLE testschema.places (id BIGINT NOT NULL, geom geometry(Geometry, 4326) NOT NULL, CONSTRAINT places_pkey PRIMARY KEY (id))

那它就很好用了。

我一定错过了一些非常简单的事情，但我检查了一遍又一遍，没有任何线索。有人有更好的主意吗？

Answer 1

确保你已经跑了

CREATE EXTENSION postgis;

然后架构限定数据类型。如果扩展是在public中创建的，请使用

CREATE TABLE places (geom public.geometry, ...);