Deleting entries from multiple tables - Mailing list pgsql-sql

From manidegr8
Subject Deleting entries from multiple tables
Date
Msg-id 1291096741884-3285654.post@n5.nabble.com
Whole thread Raw
Responses Re: Deleting entries from multiple tables  (Dusan Misic <promisic@gmail.com>)
Re: Deleting entries from multiple tables  (Dusan Misic <promisic@gmail.com>)
List pgsql-sql
i am trying to run a query but its not working may be due to constraint
conflicts

i have table A, B and C
B and C have a foreign key linked with A's primary key

so i want to delete an entry from A
for that i hav to delete child records first

can u design a query which wont conflict the constraints..?

Thanks...
Regards.
-- 
View this message in context:
http://postgresql.1045698.n5.nabble.com/Deleting-entries-from-multiple-tables-tp3285654p3285654.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.


pgsql-sql by date:

Previous
From: Jorge Arenas
Date:
Subject: Re: subselect and left join not working?
Next
From: Dusan Misic
Date:
Subject: Re: Deleting entries from multiple tables