Dsy Network>  www | forum | my | didattica | howto | wiki | el goog | stats | blog | dona | rappresentanti
Homepage
 Register   Calendar   Members  Faq   Search  Logout 
.dsy:it. : Powered by vBulletin version 2.3.1 .dsy:it. > Didattica > Corsi A - F > Basi di dati ~ comunicazione digitale > Cascade o restrict?
  Last Thread   Next Thread
Author
Thread    Expand all | Contract all    Post New Thread    Post A Reply
Collapse
stell4r
.consigliere.

User info:
Registered: Nov 2007
Posts: 107 (0.02 al dì)
Location:
Corso:
Anno:
Time Online: 13:26:51 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged
 Cascade o restrict?

Ciao ragazzi. che voi sappiate, è possibile aggiungere questa opzione dopo che le tabelle sono state costruite? e se si, come si implementa?

ho provato con alter table ma postgre mi da errore...

grazie per il vostro aiuto :)
09-10-2008 10:28
Click Here to See the Profile for stell4r Click here to Send stell4r a Private Message Find more posts by stell4r Add stell4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
ildiff
.illuminato.

User info:
Registered: May 2007
Posts: 154 (0.02 al dì)
Location: Milan
Corso: Informatica per la Comunicazione
Anno: 3 + 2
Time Online: 1 Day, 3:06:01: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Devi eliminare il vincolo di chiave esterna con un 

code:

ALTER TABLE nometabella DROP CONSTRAINT nomevincolo

e poi li ricrei con un
code:

ALTER TABLE nometabella ADD CONSTRAINT nomevincolo ....

09-10-2008 15:15
Click Here to See the Profile for ildiff Click here to Send ildiff a Private Message Find more posts by ildiff Add ildiff to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
stell4r
.consigliere.

User info:
Registered: Nov 2007
Posts: 107 (0.02 al dì)
Location:
Corso:
Anno:
Time Online: 13:26:51 [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

ma se non li metto, rischio la bocciatura? :D

non riesco a capire se sono importanti o no ..
09-10-2008 15:44
Click Here to See the Profile for stell4r Click here to Send stell4r a Private Message Find more posts by stell4r Add stell4r to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
Collapse
ildiff
.illuminato.

User info:
Registered: May 2007
Posts: 154 (0.02 al dì)
Location: Milan
Corso: Informatica per la Comunicazione
Anno: 3 + 2
Time Online: 1 Day, 3:06:01: [...]
Status: Offline

Post actions:

Edit | Report | IP: Logged

Se non gestisci correttamente le CASCADE, le NO ACTION,... sono sicure 2 cose:
1) non fai una bella figura
2) (per me) il voto ne risentirà in negativo
09-10-2008 15:55
Click Here to See the Profile for ildiff Click here to Send ildiff a Private Message Find more posts by ildiff Add ildiff to your buddy list Printer Friendly version Email this Article to a friend Reply w/Quote
All times are GMT. The time now is 15:28.    Post New Thread    Post A Reply
  Last Thread   Next Thread
Show Printable Version | Email this Page | Subscribe to this Thread | Add to Bookmarks

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts 		HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is ON
 

Powered by: vBulletin v2.3.1 - Copyright ©2000 - 2002, Jelsoft Enterprises Limited
Mantained by dsy crew (email) | Collabora con noi | Segnalaci un bug | Archive | Regolamento | Licenze | Thanks | Syndacate
Pagina generata in 0.098 seconds (62.07% PHP - 37.93% MySQL) con 26 query.