Cascade Delete To Override Table Restrict Delete

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cascade Delete To Override Table Restrict Delete
Date: 2005-05-04 16:12:40
Message-ID: 20050504161240.29737.qmail@web52404.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi all,

i have a test db set up and have dummy data in tables
that restrict deletes. i want to delete that dummy
data. i had this problem yesterday and, found a sql
statement to do it and everything was dandy.

not being too smart yesterday, i didn't save that sql
statement and i can't find it again today.

i thought is looked like...

DELETE FROM tablename WHERE constraint CASCADE;

i also tried...

DELETE FROM tablename WHERE constraint ON DELETE
CASCADE;

no luck.

any guidance here would be appreciated. tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-05-04 16:21:52 Re: Last ID Problem
Previous Message David 2005-05-04 15:39:47 Output of PL/PGSQL?