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

Поиск
Список
Период
Сортировка
От Björn Platzen
Тема Re: Can't insert date in field with foreign key
Дата
Msg-id FB26DAD89E43D411B25F0050DA517F38311DCC@MOMATEC01
обсуждение исходный текст
Ответ на Can't insert date in field with foreign key  (Björn Platzen <bjoern.platzen@momatec.de>)
Список 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 по дате отправления:

Предыдущее
От: lowen@pari.edu
Дата:
Сообщение: GUY MACON 6158 Flamingo Drive Buena Park, CA 90620
Следующее
От: "Bob Powell"
Дата:
Сообщение: making another super user other than postgres