one to many

CC me please.

How do I set up a one to many relationship in Postgres, (any DB for that
matter.)

I.E., if a delete or update of a child table causes a row in the parent
table to no longer refer to any rows in the child table, to either cause
Postgres to error out or delete the parent? I can see it does it for
when a parent is upudated or deleted.