I am developing an app in which there are 2 tables: a parent and a child.
The difference is that, in my case, the child table is generated first and,
if the user decides to keep the information then a record is generated in
the parent table and the child table is connected to its parent. The field
in the child table that connects to its parent is temporarily filled with a
value of -1. The user who types the information may decide to keep or not
the records in the child table and it is at this time when a record in the
parent table is generated or not. Meanwhile, the records in the child table
have a tamporary value of -1 in the field that will connect to its parent
table and this causes me not to be able to define a foreign key.
pgsql-novice by date
|Next:||From: Richard Broersma||Date: 2009-12-28 23:05:28|
|Subject: Re: CHILD WITHOUT PARENT (TEMPORARILY)|
|Previous:||From: Bob McConnell||Date: 2009-12-27 22:35:31|
|Subject: Re: indexes and relationships|