最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

SELECT *没有指定表无效

运维笔记admin23浏览0评论

SELECT *没有指定表无效

SELECT *没有指定表无效

我收到此错误:

{
    "name": "error",
    "length": 189,
    "severity": "ERROR",
    "code": "42601",
    "internalPosition": "8",
    "internalQuery": "SELECT *",
    "where": "PL/pgSQL function insertintoinstancedlist() line 15 at RETURN",
    "file": "parse_target.c",
    "line": "1290",
    "routine": "ExpandAllTables"
}

而我不能确定是什么导致了它作为我的触发器是一样的另一个另一只不同的表名。这里的触发:

CREATE OR REPLACE FUNCTION 
    insertIntoInstancedList () 
RETURNS TRIGGER AS $BODY$
DECLARE
BEGIN
    INSERT INTO
        creator.instanced_lists
        (
            list_id,
            account_id
        )
    VALUES
        (
            new._id,
            new.account_id
        );
    RETURN
        *;
END
$BODY$
language plpgsql;        

CREATE TRIGGER trig_list_insertion
    AFTER INSERT ON creator.lists
    FOR EACH ROW
    EXECUTE PROCEDURE insertIntoInstancedList();
回答如下:

弄清楚了。所需的RETURNNEW

INSERT INTO
    creator.instanced_lists
    (
        list_id,
        account_id
    )
VALUES
    (
        new._id,
        new.account_id
    );
RETURN
    NEW; <--- this here

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论