<font class="Apple-style-span" face="arial, sans-serif"><span class="Apple-style-span" style="border-collapse:
collapse;">Tobe precise, if you used defaults, you can't delete any row in table A that has rows referencing to it in
tablesB and C.<br /></span></font><br /><div class="gmail_quote">On Tue, Nov 30, 2010 at 6:59 AM, manidegr8 <span
dir="ltr"><<ahref="mailto:engineer.usman@ymail.com">engineer.usman@ymail.com</a>></span> wrote:<br /><blockquote
class="gmail_quote"style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><br /> i am trying to run a
querybut its not working may be due to constraint<br /> conflicts<br /><br /> i have table A, B and C<br /> B and C
havea foreign key linked with A's primary key<br /><br /> so i want to delete an entry from A<br /> for that i hav to
deletechild records first<br /><br /> can u design a query which wont conflict the constraints..?<br /><br />
Thanks...<br/> Regards.<br /> --<br /> View this message in context: <a
href="http://postgresql.1045698.n5.nabble.com/Deleting-entries-from-multiple-tables-tp3285654p3285654.html"
target="_blank">http://postgresql.1045698.n5.nabble.com/Deleting-entries-from-multiple-tables-tp3285654p3285654.html</a><br
/>Sent from the PostgreSQL - sql mailing list archive at Nabble.com.<br /><font color="#888888"><br /> --<br /> Sent
viapgsql-sql mailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make
changesto your subscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br />
