**已关闭。**此问题为not reproducible or was caused by typos。当前不接受答案。

这个问题是由错字或无法再重现的问题引起的。虽然类似的问题在这里可能是on-topic，但这个问题的解决方式不太可能帮助未来的读者。
6天前关闭。
Improve this question
我对PostgreSQL还很陌生，我想我可以从社区的帮助中受益，我正在努力让这个概念发挥作用。
它所要做的就是在数据不存在的情况下将数据插入维表中，然后返回维ID以供以后使用。错误属于CASE语句，因为我还想根据是否存在错误为success分配一个布尔值。（编辑：这里，当我说“错误”时，我指的是数据中的一个字段）。
我得到的错误声明time_stamp不存在。我以为我读到INSERT INTO RETURNING INTO会隐式创建一个临时表。看起来我一定是误解了。有人能帮我找到正确的逻辑吗？谢谢！

CREATE OR REPLACE FUNCTION distribute_process_data() RETURNS TRIGGER AS 
$BODY$ 
BEGIN
    select CURRENT_TIMESTAMP() into time_stamp;

    INSERT INTO
        sources(source, category)
        VALUES(NEW.source, NEW.category) ON CONFLICT (source) DO NOTHING
        RETURNING id INTO source_id;

    INSERT INTO
        mediums(sources_id, medium)
        VALUES(source_id, NEW.medium) ON CONFLICT (sources_id, medium) DO NOTHING
        RETURNING id INTO medium_id;

    INSERT INTO
        countries(country)
        VALUES(NEW.country) ON CONFLICT (country) DO NOTHING
        RETURNING id INTO country_id;

    INSERT INTO
        requests(sources_id, request)
        VALUES(source_id, NEW.request) ON CONFLICT (request) DO NOTHING
        RETURNING id INTO request_id;

    CASE
        WHEN NEW.error IS NOT NULL THEN
            INSERT INTO
                errors(timestamp, processes_id, error)
                VALUES(time_stamp, NEW.id, error)
                RETURNING id INTO error_id;
            select FALSE INTO success;
        ELSE
            select NULL INTO error_id;
            select TRUE INTO success;
    END CASE;

    INSERT INTO
        processes(
            id, timestamp, requests_id, errors_id, sources_id, mediums_id, countries_id, successful,
            date, web_visits, conversions, ad_impressions, ad_clicks, ad_cost, site1_ad_visits,
            site2_ad_visits, site1_ad_visits_bounce_rate, downloads_desktop, downloads_mobile,
            initiated_registrations, completed_registrations, paid_users, revenue
        )
        VALUES(
            NEW.id, time_stamp, request_id, error_id, medium_id, country_id, success,
            NEW.date, NEW.web_visits, NEW.conversions, NEW.ad_impressions, NEW.ad_clicks, NEW.ad_cost,
            NEW.site1_ad_visits, NEW.site2_ad_visits, NEW.site1_ad_visits_bounce_rate, 
            NEW.downloads_desktop, NEW.downloads_mobile, NEW.initiated_registrations, NEW.completed_registrations, 
            NEW.paid_users, NEW.revenue
        )

    RETURN new;

END;
$BODY$ language plpgsql;

我试着使用提供的代码。它不起作用，声明我的“变量”不存在。我期待它同谋创建它们。
值得一提的是，我更喜欢可读性而不是速度，因为我还是一个新用户，将负责维护代码。