On 12/06/2011 08:45 AM, Phoenix Kiula wrote:
On Sun, Dec 4, 2011 at 7:41 PM, Phoenix Kiula<phoenix.kiula@xxxxxxxxx> wrote:
On Sun, Dec 4, 2011 at 7:14 PM, Alban Hertroys<haramrae@xxxxxxxxx> 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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
