Seems like you could always whip up a stored procedure....
On May 16, 2004, at 9:27 AM, Dennis Gearon wrote:
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.
---------------------------(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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
