Re: Odd Foreign Key Bug - Mailing list pgsql-bugs

From Stephan Szabo
Subject Re: Odd Foreign Key Bug
Date
Msg-id 20031007112037.W52217@megazone.bigpanda.com
Whole thread Raw
In response to Odd Foreign Key Bug  ("Ara Anjargolian" <ara@jargol.com>)
List pgsql-bugs
On Mon, 6 Oct 2003, Ara Anjargolian wrote:
> Also notice that the foreign key constraint is not declared until after
> the table definition.  This error does not show up if the foreign key is
> added when the content table is defined.

It works the same for me as a table constraint or as an alter as long as
on update cascade is given in both cases.  It'd be nice to fail at
constraint creation time if on update cascade is given and the type on the
primary key table wasn't assignment convertable to the type on the foreign
key table.

pgsql-bugs by date:

Previous
From: "Ara Anjargolian"
Date:
Subject: Odd Foreign Key Bug
Next
From: ljb
Date:
Subject: Re: 7.4beta4: make check broken?