PostgreSQL建表报错：relation不存在，请求协助排查问题

报错原因 #

你提交的建表语句中，id字段的默认值设置为nextval('charters_id_seq'::regclass)，但charters_id_seq这个序列尚未创建，PostgreSQL找不到该对象，因此抛出relation "charters_id_seq" does not exist错误（报错截图显示错误指向nextval调用行）。

解决方法 #

有两种可行的处理方式：

方式一：提前创建序列 #

先执行语句创建依赖的序列，再运行建表SQL：

CREATE SEQUENCE IF NOT EXISTS public.charters_id_seq;

方式二：修改建表语句自动生成序列（推荐） #

PostgreSQL支持自动为自增字段创建序列，无需手动定义，修改id字段的定义即可：

• 用SERIAL类型（兼容旧版本）：

CREATE TABLE IF NOT EXISTS public.charters (
    id SERIAL NOT NULL PRIMARY KEY,
    length numeric,
    beam numeric,
    height numeric,
    passengers integer,
    berths integer,
    description text,
    "year" integer,
    power integer,
    price numeric,
    model character varying,
    skipper boolean,
    fuel_included boolean,
    gps boolean,
    shower boolean,
    main_img character varying,
    title character varying,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    "location" character varying
);

• 用IDENTITY类型（PostgreSQL 10+推荐，更符合SQL标准）：

CREATE TABLE IF NOT EXISTS public.charters (
    id integer NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    length numeric,
    beam numeric,
    height numeric,
    passengers integer,
    berths integer,
    description text,
    "year" integer,
    power integer,
    price numeric,
    model character varying,
    skipper boolean,
    fuel_included boolean,
    gps boolean,
    shower boolean,
    main_img character varying,
    title character varying,
    created_at timestamp(6) without time zone NOT NULL,
    updated_at timestamp(6) without time zone NOT NULL,
    "location" character varying
);

内容的提问来源于stack exchange，提问作者user11816068