From: "Björn Platzen" <[EMAIL PROTECTED]>
> "HST_NR" varchar(10) references "T_OEPNV_HST" on update cascade,
try:
"HST_NR" varchar(10) references T_OEPNV_HST(HST_NR) on update cascade,
gnari
---(end of broadcast)---
TIP 6: Have you searched our
=?iso-8859-1?Q?Bj=F6rn_Platzen?= <[EMAIL PROTECTED]> writes:
> CREATE TABLE "T_OEPNV_HST"
> (
> "HST_ID" serial,
> "HST_NR" varchar(10),
> ...
> CONSTRAINT "T_OEPNV_HST_pkey" PRIMARY KEY ("HST_ID"),
> CONSTRAINT "T_OEPNV_HST_unr" UNIQUE ("HST_NR"),
> ...
> CREATE TABLE "T_OEPNV_HST_LIN" (
>
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
On Thu, Nov 11, 2004 at 08:13:16AM +0100, Bjoern Platzen wrote:
> insert into "T_OEPNV_HST_LIN" ("HST_NR", "LIN_U_NAME", "LIN_KAT",
> "LIN_NAME_O", "LIN_NAME_I") values ('10001', 'Stadtwerke Marburg GmbH',
> 'Bus', 'C', '11103');
> does not work while
> select * from "T_OEPNV_HST" where "HST_NR
