How to avoid updation anomaly like this :
While trying to update in the parent table it says child record exists
while trying to update in the child table it says parent record exists
I am trying to update the foreign key column in both the tables ?
Also how to delete a foreign key constraint ?
Get Your Private, Free Email at http://www.hotmail.com
pgsql-sql by date
|Next:||From: D.N.MURTY||Date: 2000-04-12 19:16:38|
|Subject: query from D. N. Murty|
|Previous:||From: Tom Lane||Date: 2000-04-12 18:10:50|
|Subject: Re: UNION support for rules |