Deleting entries from multiple tables

Поиск
Список
Период
Сортировка
От manidegr8
Тема Deleting entries from multiple tables
Дата
Msg-id 1291096741884-3285654.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: Deleting entries from multiple tables
Re: Deleting entries from multiple tables
Список 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 по дате отправления:

Предыдущее
От: Jorge Arenas
Дата:
Сообщение: Re: subselect and left join not working?
Следующее
От: Dusan Misic
Дата:
Сообщение: Re: Deleting entries from multiple tables