Re: Can't insert date in field with foreign key - Mailing list pgsql-general

From Björn Platzen
Subject Re: Can't insert date in field with foreign key
Date
Msg-id FB26DAD89E43D411B25F0050DA517F38311DCC@MOMATEC01
Whole thread Raw
In response to Can't insert date in field with foreign key  (Björn Platzen <bjoern.platzen@momatec.de>)
List 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.


pgsql-general by date:

Previous
From: lowen@pari.edu
Date:
Subject: GUY MACON 6158 Flamingo Drive Buena Park, CA 90620
Next
From: "Bob Powell"
Date:
Subject: making another super user other than postgres