Referential cycle: ON DELETE CASCADE?

Question

enter image description here

If "predmet" is a FK to "predmeti", and "nositelj" is a FK to "nastavnici",

what will happen if I specify ON DELETE CASCADE to both foreign keys and delete one of the entities? Would it produce an error?

Edit: I'm using the latest version of PostgreSQL.

If you use and refer to an image, it might help if it were readable — vol7ron, Dec 16 '12 at 22:00
`What will happen if I specify ON DELETE CASCADE to both foreign keys and delete one of the entities?` I don't know... what *will* happen? `Would it produce an error?` I don't know... does it? What have you tried? — vol7ron, Dec 16 '12 at 22:03
Closely related: http://stackoverflow.com/questions/8394177/complex-foreign-key-constraint-in-sqlalchemy — Erwin Brandstetter, Dec 17 '12 at 02:01

burnall · Accepted Answer · 2012-12-16T22:16:54.913

1

Read manual for your RDBMS (you have not specified it). Typically circular cascade forbidden - you will get an error on create.

UPDATED: try http://sqlfiddle.com/#!1/24df4/2/0 It seems it is not forbidden - remove recursively.

Someone very kind minused me, because i have fixed the tags and it makes my post incorrect)

edited Dec 16 '12 at 22:16

answered Dec 16 '12 at 20:29

burnall

I'm using the latest PostgreSQL. – Tool Dec 16 '12 at 20:30
2

@Tool 9.2.2? It's the latest *now*, but what about people reading this lateR? – Craig Ringer Dec 17 '12 at 02:57

1 Answers1