Re: [ADMIN] delete cascade question

2004-04-27 Thread Stephan Szabo
On Tue, 27 Apr 2004, Glenn MacGregor wrote: > Now I need to change the parentname field (in the case of vimid = 2) > from [EMAIL PROTECTED] to test and keep the vimname field as is. When I do > this the constraint no longer works (which makes perfect sense). > > 1 | [EMAIL PROTECTED] | cell | f |

Re: [ADMIN] delete cascade question

2004-04-27 Thread Glenn MacGregor
Sorry for being too vague. Here is my exact situation. I have the following table currently: Table "xpressvim" Column| Type | Modifiers -++---

Re: [ADMIN] delete cascade question

2004-04-26 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > I am using a cascade delete on the following table: > ... > So the delete cascade states if I am deleting a row whose vname > matches the parentname delete those rows and it works fine. > ... > This works, so I tried to put that in the cascade bu

[ADMIN] delete cascade question

2004-04-26 Thread Glenn MacGregor
Hi All, I am using a cascade delete on the following table: vid vname parentname 1[EMAIL PROTECTED] 2[EMAIL PROTECTED] [EMAIL PROTECTED] 3[EMAIL PROTECTED] [EMAIL PROTECTED] 4[EMAIL PROTECTED] [EMAIL P