我有一个奇怪的问题与PostgreSQL.它表明，一个过程不存在，而我认为我创建了它.我真的不明白.我试图删除参数，只是为了看看我是否会有同样的问题或另一个，但我仍然得到了同样的问题.
下面是我的代码：

DROP TABLE IF EXISTS clients, accounts, transactions, failed_transactions CASCADE;

CREATE TABLE IF NOT EXISTS clients
(
    id int PRIMARY KEY,
    name varchar
);

CREATE TABLE IF NOT EXISTS accounts
(
    id int PRIMARY KEY,
    balance float,
    client int,
    FOREIGN KEY (client) REFERENCES clients(id),
    CHECK (balance >= -500)
);

CREATE TABLE IF NOT EXISTS transactions
(
    id serial PRIMARY KEY,
    amount float
);

CREATE TABLE failed_transactions
(
    id serial,
    account_id integer,
    attempted_amount float,
    timestamp timestamp DEFAULT NOW()
);

CREATE OR REPLACE PROCEDURE log_failed_transaction(new_line record, old_line record)
LANGUAGE plpgsql
AS $$
BEGIN
    IF new_line.balance<-500 THEN
        INSERT INTO failed_transactions(account_id, attempted_amount)
                    VALUES (new_line.id, new_line.balance-old_line.balance);
    END IF;
END $$;


CREATE OR REPLACE TRIGGER accounts_update BEFORE UPDATE ON accounts
FOR EACH STATEMENT
EXECUTE PROCEDURE log_failed_transaction(NEW, OLD);

INSERT INTO clients VALUES (10, 'Client 1');
INSERT INTO clients VALUES (14, 'Client 2');
INSERT INTO clients VALUES (25, 'Client 3');

INSERT INTO accounts VALUES (8, 2000, 14);
INSERT INTO accounts VALUES (12, 650, 10);
INSERT INTO accounts VALUES (2, 300, 25);

字符串