Re: Foreign keys question (performance)

On 12/06/2011 08:45 AM, Phoenix Kiula wrote:
> On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiula<phoenix.kiula@gmail.com>  wrote:
>> On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys<haramrae@gmail.com>  wrote:
>>> On 4 Dec 2011, at 11:19, Phoenix Kiula wrote:
>
>
> I have a problem.
>
> Here's my table designs. The problem is that if Table 1 (stores) has a
> foreign key reference from another child table (stores_registered),
> then when I update Table 1, it throws an error that referential
> intergrity is being violate because Table 2 depends on Table 1.
> However, if I update Table 2 first, it tells me  that the fkey in
> Table 1 doesn't exist (of course).
>
> Any ideas? What am I missing? How do updates work in terms of CASCADE?

What is the actual error message?

>
> Thanks!
>


--
Adrian Klaver
adrian.klaver@gmail.com