Re: Can't insert date in field with foreign key

From: Björn Platzen <bjoern(dot)platzen(at)momatec(dot)de>
To: "'Michael Fuhr'" <mike(at)fuhr(dot)org>
Cc: "'PostgreSQL List'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't insert date in field with foreign key
Date: 2004-11-11 08:53:19
Message-ID: FB26DAD89E43D411B25F0050DA517F38311DCC@MOMATEC01
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Michael,

> The foreign key constraint on T_OEPNV_HST_LIN.HST_NR
> references the wrong field in T_OEPNV_HST. Since you didn't
> specify a field, it's referencing the primary key HST_ID
> instead of HST_NR.

OK. Now I know what's wrong. I thought (for some reason) that if the
columns have the same name, I would not have to reference an explicit
column by it's name.

Thanks (as well to gnari who pointed me to the same issue),

Bjoern.

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2004-11-11 10:55:33 Problem with showing time diff?
Previous Message gnari 2004-11-11 08:34:36 Re: Can't insert date in field with foreign key