| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Glenn MacGregor <gtm(at)highstreetnetworks(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Cascade delete question |
| Date: | 2004-04-23 03:03:27 |
| Message-ID: | 20040423030327.GA828@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Apr 22, 2004 at 16:46:31 -0400,
Glenn MacGregor <gtm(at)highstreetnetworks(dot)com> wrote:
>
> No problem this works great!
>
> Now I have changed my data to
>
> vid vname parentname
> 1 n1(at)test(dot)com
> 2 n2(at)test(dot)com n1
> 3 n3(at)test(dot)com n1
> 4 n4(at)test(dot)com n1
> 5 n5(at)test(dot)com n3
>
> Can I change my delete cascade constraint to do this substring query
> instead of an exact match?
No.
> Is there anyway to accomplish what I need to do?
If the local part of the email address is a candidate key, separate it
from the domain name and make it the primary key.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eloy Mier Prez | 2004-04-23 09:21:21 | How configure Oracle 9i not case sensitive... |
| Previous Message | Glenn MacGregor | 2004-04-22 20:46:31 | Cascade delete question |