On Tue, 14 Aug 2001, Jan Wieck wrote:
> Mister ics wrote:
> > testdb=>create table t1 (
> > id int primary key,
> > foo int);
> > testdb=>create table t2 (
> > id int primary key,
> > ref int references t1(id) on update restrict);
> So an attempt to
>
> UPDATE t1 SET id = 2 WHERE id = 1;
>
> is the thing prevented in your above example.
I find it odd that you specify a restiction on one table in the definition of
another table.
Sorry, if this was a double post.
Alan Gutierrez