sql - 删除级联的外键约束不起作用postgres

Question

当我运行 DELETE FROM users WHERE id='some_id' 时，beta_keys 表上的记录不会被删除。

beta_keys 表:

CREATE TABLE beta_keys (
    id serial PRIMARY KEY,
    key VARCHAR(60) UNIQUE NOT NULL,
    created_at TIMESTAMP NOT NULL,
    updated_at TIMESTAMP
);

用户表:

CREATE TABLE users (
    id serial PRIMARY KEY,
    email VARCHAR (256) UNIQUE NOT NULL,
    password VARCHAR (60) NOT NULL,
    beta_key_id INTEGER,
    created_at TIMESTAMP NOT NULL,
    updated_at TIMESTAMP,
    CONSTRAINT users_beta_key_id_fkey FOREIGN KEY (beta_key_id)
        REFERENCES beta_keys (id) MATCH SIMPLE
        ON DELETE CASCADE
);

Answer 1

users 引用 beta_keys。 delete cascade 通过在删除引用行 (beta_keys) 时删除引用行 (users) 来工作。

sqlfiddle:http://sqlfiddle.com/#!17/a7495/1