Re: CHILD WITHOUT PARENT (TEMPORARILY)

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: CHILD WITHOUT PARENT (TEMPORARILY)
Date: 2009-12-28 23:05:28
Message-ID: 396486430912281505k3f48a7c9j8471c871506de0a4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, Dec 28, 2009 at 2:58 PM, JORGE MALDONADO <jorgemal1960(at)gmail(dot)com> wrote:
>
The field
> in the child table that connects to its parent is temporarily filled with a
> value of -1... this causes me not to be able to define a foreign key.

Rather than using -1, perhaps you should use null. This would be a
valid for it.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Jasen Betts 2009-12-29 02:40:03 Re: CHILD WITHOUT PARENT (TEMPORARILY)
Previous Message JORGE MALDONADO 2009-12-28 22:58:59 CHILD WITHOUT PARENT (TEMPORARILY)