Re: on update restrict - Mailing list pgsql-sql

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