Ticket #1332930 (Feature Requests)

Martin Marques martin at bugs.unl.edu.ar
Tue Aug 15 14:18:41 CEST 2006

On Mon, 14 Aug 2006, Eric Stadtherr wrote:

> Thomas,
> I wouldn't put the cascade delete on the type constraint, though (you 
> don't want to lose the ability to enter phone numbers just because you 
> deleted your last phone number... Wink ).

On CASCADE means that if you eliminate or update a PK, it will cascade to 
the refereced keys. If you eliminate the last phone number, you're just 
eliminating rows that reference th PK, so no CASCADE is done.

Those CASCADE are more like, if you eliminate the contact, all the info of 
that contact will be eliminated.

  21:50:04 up 2 days,  9:07,  0 users,  load average: 0.92, 0.37, 0.18
Lic. Martín Marqués         |   SELECT 'mmarques' ||
Centro de Telemática        |       '@' || 'unl.edu.ar';
Universidad Nacional        |   DBA, Programador,
     del Litoral             |   Administrador

More information about the Dev mailing list