471,092 Members | 1,768 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,092 software developers and data experts.

One more time on ONE-TO-MANY

CC me, I'm digesting this list.

From:
http://www.sum-it.nl/cursus/dbdesign.../intro030.php3
A quote:
' 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
<http://www.sum-it.nl/cursus/dbdesign/english/intro030.php3#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
post trigger.

Does anyone have experience with a database that will do the last one,
and what database would that be?

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
0 878

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Benoit BESSE | last post: by
4 posts views Thread by Radioactive Man | last post: by
20 posts views Thread by Jean Johnson | last post: by
8 posts views Thread by flamesrock | last post: by
1 post views Thread by shaanxxx | last post: by
5 posts views Thread by 2good2b | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.