Skip site navigation (1) Skip section navigation (2)

Re: Cascade delete question

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 (view raw or flat)
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.

In response to

pgsql-admin by date

Next:From: Eloy Mier PrezDate: 2004-04-23 09:21:21
Subject: How configure Oracle 9i not case sensitive...
Previous:From: Glenn MacGregorDate: 2004-04-22 20:46:31
Subject: Cascade delete question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group