postgres ：reverse table error #8

New Issue

jerry · 2020-03-14T12:35:34Z

jerry commented

2020-03-14 12:35:34 +00:00

error问题如图：

数据库表结构如下：

-- auto-generated definition
create table ir_filters
(
    id          serial  not null
        constraint ir_filters_pkey
            primary key,
    name        varchar not null,
    user_id     integer
        constraint ir_filters_user_id_fkey
            references res_users
            on delete cascade,
    domain      text    not null,
    context     text    not null,
    sort        text    not null,
    model_id    varchar not null,
    is_default  boolean,
    action_id   integer,
    active      boolean,
    create_uid  integer
        constraint ir_filters_create_uid_fkey
            references res_users
            on delete set null,
    create_date timestamp,
    write_uid   integer
        constraint ir_filters_write_uid_fkey
            references res_users
            on delete set null,
    write_date  timestamp,
    constraint ir_filters_name_model_uid_unique
        unique (name, model_id, user_id, action_id)
);

comment on table ir_filters is 'Filters';

comment on column ir_filters.name is 'Filter Name';

comment on column ir_filters.user_id is 'User';

comment on column ir_filters.domain is 'Domain';

comment on column ir_filters.context is 'Context';

comment on column ir_filters.sort is 'Sort';

comment on column ir_filters.model_id is 'Model';

comment on column ir_filters.is_default is 'Default Filter';

comment on column ir_filters.action_id is 'Action';

comment on column ir_filters.active is 'Active';

comment on column ir_filters.create_uid is 'Created by';

comment on column ir_filters.create_date is 'Created on';

comment on column ir_filters.write_uid is 'Last Updated by';

comment on column ir_filters.write_date is 'Last Updated on';

comment on constraint ir_filters_name_model_uid_unique on ir_filters is 'unique (name, model_id, user_id, action_id)';

alter table ir_filters
    owner to gleke;

create unique index ir_filters_name_model_uid_unique_action_index
    on ir_filters (lower(name::text), model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer)

error问题如图：数据库表结构如下： ``` -- auto-generated definition create table ir_filters ( id serial not null constraint ir_filters_pkey primary key, name varchar not null, user_id integer constraint ir_filters_user_id_fkey references res_users on delete cascade, domain text not null, context text not null, sort text not null, model_id varchar not null, is_default boolean, action_id integer, active boolean, create_uid integer constraint ir_filters_create_uid_fkey references res_users on delete set null, create_date timestamp, write_uid integer constraint ir_filters_write_uid_fkey references res_users on delete set null, write_date timestamp, constraint ir_filters_name_model_uid_unique unique (name, model_id, user_id, action_id) ); comment on table ir_filters is 'Filters'; comment on column ir_filters.name is 'Filter Name'; comment on column ir_filters.user_id is 'User'; comment on column ir_filters.domain is 'Domain'; comment on column ir_filters.context is 'Context'; comment on column ir_filters.sort is 'Sort'; comment on column ir_filters.model_id is 'Model'; comment on column ir_filters.is_default is 'Default Filter'; comment on column ir_filters.action_id is 'Action'; comment on column ir_filters.active is 'Active'; comment on column ir_filters.create_uid is 'Created by'; comment on column ir_filters.create_date is 'Created on'; comment on column ir_filters.write_uid is 'Last Updated by'; comment on column ir_filters.write_date is 'Last Updated on'; comment on constraint ir_filters_name_model_uid_unique on ir_filters is 'unique (name, model_id, user_id, action_id)'; alter table ir_filters owner to gleke; create unique index ir_filters_name_model_uid_unique_action_index on ir_filters (lower(name::text), model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer) ```

微信图片_20200314203403.png

14 KiB