To be precise, if you used defaults, you can't delete any row in table A that has rows referencing to it in tables B and C.
On Tue, Nov 30, 2010 at 6:59 AM, manidegr8 <engineer.us...@ymail.com> wrote: > > 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. > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql >
