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(dot)kiula(at)gmail(dot)com> wrote:
>> On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys<haramrae(at)gmail(dot)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(dot)klaver(at)gmail(dot)com