Re: Quick question re foreign keys.
| От | Robins Tharakan |
|---|---|
| Тема | Re: Quick question re foreign keys. |
| Дата | |
| Msg-id | 36af4bed0710240727i3b8b2753q1fd0dd5397a3e4f0@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Quick question re foreign keys. (Paul Lambert <paul.lambert@autoledgers.com.au>) |
| Список | 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.lambert@autoledgers.com.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
В списке pgsql-sql по дате отправления: