CC me, I'm digesting this list.
' In addition *the database designer chooses* an action for delete:
* It's /only possible/ to delete a row in the one-table when there a
no more related many-rows.
* When deleting a row the RDBMS
/automatically/ deletes the related data in the many table. This
is called a /cascaded delete/.
* When deleting the last 'many' the RDBMS /automatically/ deletes
the related 'one' row.'
I'm pretty sure that Postgres does not support the last one
automatically. I shall have to do that one by either a chron script or a
Does anyone have experience with a database that will do the last one,
and what database would that be?
pgsql-general by date
|Next:||From: Duane Lee - EGOVX||Date: 2004-05-26 23:19:41|
|Subject: Re: One more time on ONE-TO-MANY|
|Previous:||From: Sean Shanny||Date: 2004-05-26 22:12:15|
|Subject: Re: Problem with sequences on a reload of a pg_dump file|