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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
