postgresql - Postgres : problem with FK contraint

Question

如何解决 FK 约束？带触发器还是其他东西？

#IF "DELETE FROM human where name='a';", error due to the FK contraist.

# If the error, I want in the order:
# FIRSTLY. DELETE FROM address where name='a';
# SECONDLY. DELETE FROM human where name='a';


DROP TABLE human;
DROP TABLE address;

CREATE TABLE human(
        name varchar(300) PRIMARY KEY not null

);

CREATE TABLE address(
        name varchar(300)
                references human.name

);

Answer 1

CREATE TABLE address (
    name varchar(300) REFERENCES human (name) ON DELETE CASCADE
);

这是你想要的吗？