| From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
|---|---|
| To: | Ara Anjargolian <ara(at)jargol(dot)com> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Odd Foreign Key Bug |
| Date: | 2003-10-07 18:23:44 |
| Message-ID: | 20031007112037.W52217@megazone.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Branden R. Williams | 2003-10-07 21:12:57 | Bug Report |
| Previous Message | Viacheslav N Tararin | 2003-10-07 13:37:00 | bug in detection number of updated rows on view with rules. |