Re: [GENERAL] Lionel Lauer 58 Gore Street Fitzroy, Victoria Australia 3065

Hello, I'm new to the list (since yesterday evening) and I'm wondering what kind of jokes are spamming my mailbox! I can't laugh at all ... ... maybe I just don't understand ... However ... Bye, Bjoern. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Beh

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

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

[GENERAL] Can't insert date in field with foreign key

Hello list, I'm a postgres-newbie with a maybe silly question. I'm working on a SuSE-Linux 9.1 with PostgreSQL 7.4.6 with PostGIS 0.9. My problem is, that I can't insert data into a table because I get the error, that there is no corresponding value in the referenced field. But when I query the r