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.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
