From: | "Robins Tharakan" <tharakan(at)gmail(dot)com> |
---|---|
To: | "Paul Lambert" <paul(dot)lambert(at)autoledgers(dot)com(dot)au> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Quick question re foreign keys. |
Date: | 2007-10-24 14:27:44 |
Message-ID: | 36af4bed0710240727i3b8b2753q1fd0dd5397a3e4f0@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Forgive my butting in, but frankly, most of the times, whenever I find
myself in a very 'exceptional problem' such as this one, I always end up
questioning the basic design due to which I am stuck in the first place.
Paul, it seems that probably there is a basic design issue here.
All the best :)
Robins
On 10/24/07, Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> wrote:
>
> Paul Lambert wrote:
> >
> > It's marked not null as a result of being part of the primary key for
> > that table which I can't really get around.
> >
> > I can get away with not having the foreign key though, so I'll have to
> > go down that path.
> >
> > Cheers,
> > P.
> >
>
> Ignore this whole thread actually.
>
> I need to rethink some of my design.
>
> --
> Paul Lambert
> Database Administrator
> AutoLedgers
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 2007-10-24 14:53:43 | Re: Quick question re foreign keys. |
Previous Message | Fernando Hevia | 2007-10-24 13:56:03 | Re: request for help with COPY syntax |